From: Date: August 2 2004 2:10pm
Subject: MySQL using lots of CPU time
List-Archive: http://lists.mysql.com/win32/15297
Message-Id: <000801c47889$b7293400$5d7025c4@greg>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0005_01C4789A.7A97EC50"

------=_NextPart_000_0005_01C4789A.7A97EC50
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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


------=_NextPart_000_0005_01C4789A.7A97EC50--