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