Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

Sleeping Queries [message #119] Wed, 30 August 2006 15:58  sbazemore Messages: 4 Registered: August 2006 Location: Charlotte, North Carolina Junior Member 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 Report message to a moderator

	Sleeping Queries By: sbazemore on Wed, 30 August 2006 15:58
	Re: Sleeping Queries By: Peter on Wed, 30 August 2006 16:54
	Re: Sleeping Queries By: sbazemore on Wed, 30 August 2006 17:02
	Re: Sleeping Queries By: Peter on Wed, 30 August 2006 17:14
	Re: Sleeping Queries By: toasty on Fri, 01 September 2006 05:31
	Re: Sleeping Queries By: sbazemore on Fri, 01 September 2006 09:08
	Re: Sleeping Queries By: Peter on Fri, 01 September 2006 09:15

Previous Topic:	General query log performance
Next Topic:	help

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]