Pada Fri, 26 Jul 2002 11:17:08 -0700
Troy Hakala <[EMAIL PROTECTED]> menulis :
> 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 my server, recently i also get "too many connection" or "can't create more thread"
more frequent.
after doing investigation few times, i found that it can be caused by problem on our
tables. and can be solved by repairing the table.
and also to avoid this sleeping threads, you can set the interactive_timeout to
reasonable value or run command to kill sleep/idle processes which sleeping over
sometimes.
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 35 days, Queries : 355.738 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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
