Thanks All for reply my message. After I reconfigured mysql server, I did load test. When mysql server reached 99.7%, but CUP resource is only at 50%. Since this server is mysql database only.
Is there a way I can change some mysql system variables to increase CUP resource usage to 80%-90% when mysql max out. When I did load test, There only one CUP is in use, but they switch to each other. Is this normal, or I did configure wrong for my FreeBSD box? Thanks again guys. William -----Original Message----- From: John Wards [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 6:31 AM To: William Wang; [EMAIL PROTECTED] Subject: Re: very slow mysql server, help please On Thursday 06 Mar 2003 3:11 am, William Wang wrote: > Question 1: Does sleeping processes slow down database server? Nope, I have had many a discussion whats best to use, pcconect or normall connect but have yet to conclude what is better. We feel that pconnect works best for us. > Question 2: Any ideas, why is the database so slow? We have been having huge problems with mySQL for months now running on freebsd so we decided to try using linuxthreads and also upgrade to mysql 4. This has done the trick and its actually serving the pages quicker because we have turned query caching on. I would say try installing linuxthreads then recompile your current version of mySQL to have linuxthread support. If that doesn't work try upgrading to 4. HTH Cheers John Wards SportNetwork.net --------------------------------------------------------------------- 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