Tuesday, January 29, 2002, 1:57:21 AM, David Piasecki wrote:
> 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? wrong threads library -- Dimitry --------------------------------------------------------------------- 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
