On 14 Apr 2001 23:30:51 -0400, Gary Huntress wrote:
> I've noticed, by doing "show processlist", that a few users end up with
> dozens (sometimes 50) sleeping processessome are 4 hours old. What is
> this typically caused by? I believe that most of my users connect using
> php, and I believe that if they omit mysql_close() that the connection is
> supposed to be closed automatically when their script ends.
>
> Are there other situations that would lead to this many ancient sleeping
> processes?
Don't worry about them These are prorably PHP or something other
persistent connections and MySQL drops them in case of inactivity in 8
hours.
Tõnu
-
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
