I have a server here that is troubling me -

I have a database server that is lagging no matter what I do. When I
start the server, I can watch CPU usage slowly creep up to 99% and it
never drops. The queries that are hitting the database are not terribly
involved, and should be completing quickly, but of course over time the
queries take longer and longer to complete. Eventually queries take an
excruciatingly long time and of course users on the web site are simply
stopping.

The machine is a dual processor intel 1ghz with 2 gigs of ram running
FreeBSD currently using 3.23.43 of mysql (though we have tried other
versions with the same result).

The database is getting anywhere from 0 to 20 simultaneous connections,
and most of the queries are extremely short and sweet, with just a
handful that would take several seconds to complete.

At this point I am wondering if this might be either a hardware or
operating system problem. The server has been rebooted numerous times
with the same end result.

Has anyone else had similar problems? Any ideas?


David Piasecki



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to