I have three web server (DUAL 1.4 G MHZ, 1G RAM) connect to one mysql database server (DUAL 2.2 G MHZ, 2 G RAM), SSL accelerator and a load balancer. All those servers are FreeBSD. For some reason, mysql server can be easily max out without many users. Also there are many processes in sleep (some of them has been put in sleep for over 3000 seconds.)
My database has nearly 140 tables, but there are less than 10000 recorders. Database file size is about 3M. One of the table has a BLOB field (Hold some images for my web server.). I am using mysql_pconnect() (Of cause, I tried mysql_connect(), but it's does not make big different.).
Question 1: Does sleeping processes slow down database server? Question 2: Any ideas, why is the database so slow?
Any suggestions?
Thanks in advance and for Reading my message.
William
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail
--------------------------------------------------------------------- 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
