On Thu, Aug 14, 2003 at 11:17:35AM -1000, Randall Oshita wrote: > When I run processlist it shows alot of process by the same db which > looks like MySQL does not release. It keeps getting bigger and bigger > when client access until the user count is maxed and then does not > accept any connections. Any ideas why it don't release them?
I suspect it has something to do with the client side. For example, a lot of scripts setup a new MySQL connection each time a SQL call is made instead of reusing the existing connection and not closing the existing sessions. -Vince
