I've noticed, by doing "show processlist", that a few users end up with
dozens (sometimes 50) sleeping processes....some 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?
Regards,
Gary "SuperID" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
---------------------------------------------------------------------
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