Patrick Meyer wrote:
> I am slowly gaining connections to the database that just sleep. I know
> these can arise from not closing the database. I am accessing it via MyODBC
> from Active Server Pages. However, I set wait_timeout to 3600... I have
> some that have been there for days... just sleeping. Why doesn't MySQL
> disconnect them from the timeout? Maybe I just don't understand
> wait_timeout.
I'm glad it's not just me. I have 2 v3.22.32 servers running under
HP-UX 10.20
Both servers are being used by FCGI processes on the web with persistant
connections to the database servers.
One MySQL server heeds the 'wait_timeout' value, the other ignores it
and keeps threads running for 'ever'.
Any ideas please ?
--
Andrew Benham [EMAIL PROTECTED]
Nortel Networks Plc, London Road, Harlow, Essex CM17 9NA, United Kingdom
Tel: +44 1279 402372 Fax: +44 1279 405746
I speak for myself, my views are not necessarily the views
of Nortel Networks or any other corporation.
---------------------------------------------------------------------
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
