RE: MySQL using lots of CPU time

[Armando]

I doubt CPU usage is your problem. If your web application is that
intensive then 2% should be an acceptable value and shouldn't cause
server lag at all. I run MySQL on an AMD 1.4 GHz Thunderbird (768 MB
RAM) along with 3 Quake III servers running simultaneously and I never
have server lag issues, even when MySQL starts to chew up 4 or 5% of CPU
time. Perhaps check to see your memory usages during peak operating
times. 1 GB of RAM should be more than sufficient, but check what your
other applications (particularly your web application-related files such
as DLLHOST) are using to see if one of those is causing it.

I recall a time awhile back where I had not been properly destroying the
memory-eating objects in one of my webpages and noticed after a short
time that my server would start slowing down. On investigation I had
noticed DLLHOST was using about 500 MB of my RAM (between physical and
virtual) because I hadn't been properly destroying the objects and it
continued to chew up my server memory. The lag was caused by the virtual
memory HDD swapping. Cheers.

Armando

-----Original Message-----
From: Greg Quinn [mailto:greg@stripped] 
Sent: August 2, 2004 7:11 AM
To: win32@stripped
Subject: MySQL using lots of CPU time


We are running MySQL 4.1.1 on our Windows Server, it is a Pentium 4
2.8Ghz with 1 Gig Ram.

It is serving our web application, the web application is quite
intensive, it serves email up for our 5 users. Also, when the web
application is open, each user has a page that refreshes every 30
seconds that runs about 20 queries and opens and closes about 20
connections.

Our server often gets slow, and the mysqld.exe process seems to use 2%
of the CPU almost all the time. Which seems to slow down our server
tremendously.

I have been through the optimisations in the MySQL Manual and have made
1 or 2 adjustments, but this still seems too CPU intensive for what the
database is serving....

Anybody got some ideas or things I can check for...?

Thanks