Gary Huntress writes:
> 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
>
Hi!
wait_timeout is a time in seconds that connection will spend in
'Sleep' time only (!) before being killed by the server.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
