wait_timeout and idle connections
I have wait_timeout and interactive_timeout both set to 28800 seconds and I can still see "older" connections in SHOW PROCESSLIST:
4183489 svbsoftsk host:43790 svbsoftsk Sleep 295239 --- ---
4187860 svbsoftsk host:49169 svbsoftsk Sleep 295118 --- ---
5178779 svbsoftsk host:55306 svbsoftsk Sleep 190604 --- ---
5178789 svbsoftsk host:55316 svbsoftsk Sleep 190604 --- ---
5178847 svbsoftsk host:55368 svbsoftsk Sleep 190690 --- ---
5178849 svbsoftsk host:55370 svbsoftsk Sleep 190604 --- ---
These connections are from tomcat 3.3 (using mysql-connector), but I think this shoudln't matter. Why doesn't mysqld kill these idle connections?
I'm using debian sarge with MySQL 4.0.24_Debian-10-log.
Subject
Written By
Posted
wait_timeout and idle connections
July 29, 2005 12:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.