Hi William, Sleeping processes are the result of persisitant connections and should not slow down your server. As to why you server is "so slow" you will have to provide specific examples of what is slow. We reach speeds of 600 queries per second on slower hardware. Also please indicated languages used for examples and versions of FreeBSD, MySQL and PHP (if you use PHP).
Also there are many tunable parameters (http://www.mysql.com/doc/en/Server_parameters.html) I recommend Paul Dubois Book on MySQL http://www.amazon.com/exec/obidos/tg/detail/-/0735712123/qid=104696018 6/sr=1-4/ref=sr_1_4/103-5030472-7439844?v=glance&s=books Best of Luck, Ken ----- Original Message ----- From: "William Wang" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 10:11 PM Subject: very slow mysql server, help please > > Hi All: > 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 > > > -------------------------------------------------------------------- - > 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 > > --------------------------------------------------------------------- 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