Why would mysql not clear sleeping queries properly?
In order for our site to run, we have to set our wait_timeout to 5 in to properly clear the connections or we reach our max connections in a matter of seconds.
If we set the wait_timeout to the default of 28800, most of the sleeping connections never clear out until they hit that limit which causes the connection count to max out constantly.
Any pointers would be highly appreciated.
Thanks
Stephen