Hi,
I've started mysql with the parameter -O wait_timeout=1000 and verified
that it is set using show variables. Yet I routinely see lingering
processes with times over 1100 and higher. I have about 1000 active
database users at the moment, most are connecting via php pages and I had
been running out of connections. I could have increased the number of
connections, but I chose rather to lower the wait_timeout instead.
Should I be expecting timeouts in excess of 100 seconds beyond the value
that I set? That is, is wait_timeout more of a guideline than a hard
limit?
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
