MYSQL - CPU usage high on Windows 2003

[6fingers]

Can anyone help with this issue? - I've been working on this for about a week now... When there is a lot of activity/traffic on the site mysql procees seems to "lock up" with high CPU usage and everything in windows seems to freeze. I am running mysql 4 on IIS 6 using an odbc connection via ASP. I've tried everything, indexing, optimizing, pooling, disabled the virus software running in the background, I even tried using my.cmf, etc, nothing seems to help. Is there anyone who can help or anyone else experiencing this same problem? Could it be a hardware issue? Memory?

Going insane!!!
Thanks in advance, Phil

 

[Bastien]

Yes it is a memory problem. Ensure with windoze that you explicitly CLOSE every connection made as soon as possible with mysql_close and mysql_free_result to free up the memory....

Also consider adding some more memory to the server if possible

hth

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!