ok, i turns out I have lots of sleeping connections. This is because I'm using PHP's mysql_pconnect which opens persistent connections so the next connect (on the same process) will reuse the connection. this does appear to improve performance overall, which is good. but it seems to leave lots of sleeping processes on the SQL server.
so my question is this: do sleeping connections ever get reused by MySQL? or do they just timeout eventually and waste resources while they're sleeping? Thanks! On Thursday, July 25, 2002, at 04:07 PM, Dicky Wahyu Purnomo wrote: > Pada Thu, 25 Jul 2002 09:48:40 -0700 > Troy Hakala <[EMAIL PROTECTED]> menulis : > >> I've been running MySQL for 2 years with no problems. Yesterday, I >> increased the max_connections because I was getting "too many >> connections" >> error. This morning, the server again reached its limit but it never >> seemed to recover from it and constantly gave the "too many connections" >> error. I was forced to kill & restart the server. > > you should check the running processes on your mysqld from show > processlist. > you might have a lot of sleep/idle connection. > > my suggestion : > first, you have to make sure there is no problem with your tables, run > "mysqlcheck -or -p -A" > after that you check is there any changes on "too many connection" > problem. > > check also from system : netstat -an | grep 3306 > > -- > Look, I'm about to buy me a double barreled sawed off shotgun and show > Linus what I think about backspace and delete not working. > -- some anonymous .signature > > MySQL 3.23.51 : up 34 days, Queries : 355.208 per second (avg). > > -- > Dicky Wahyu Purnomo - System Administrator > PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) > Phone : +62 21 79199577 - Web : http://1rstwap.com > > > --------------------------------------------------------------------- > 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 <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Troy Hakala Recipezaar.com --------------------------------------------------------------------- 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
