MySQL using lots of CPU time

[Greg Quinn]

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