Hi, I found my MySQL's connections are keeping increasing recently. I setted the timeout as below: | interactive_timeout | 14400 | | wait_timeout | 14400 |
When I run processlist, I found there are a lot of connections over 14400 but the connections are still sleeping. That's why my connections are keep inceasing. 61534 admin 192.168.1.10 abc 40099 Sleep 60027 admin 192.168.1.10 abc 40090 Sleep 61554 admin 192.168.1.10 abc 40041 Sleep 61732 admin 192.168.1.10 abc 39825 Sleep Could anyone tell how to fix it? I am using MySQL-4.0.20 with Max on RedHat 9. Thanks Linda
