On Mon, Nov 29, 2010 at 2:21 PM, Peter Wang wrote:
> We had have a similar problem caused by broken network-card, use
> `/sbin/ifconfig | grep errors' to check errors/dropped counter. for
> example, broken network-card may cause many connections, since normal
> tcp connect open/close can't be co
Johan De Meersman writes:
Hi,
You may check the network at that time.
We had have a similar problem caused by broken network-card, use
`/sbin/ifconfig | grep errors' to check errors/dropped counter. for
example, broken network-card may cause many connections, since normal
tcp connect open/cl
300 seconds is 5 minutes, while this whole thing happened probably under a
minute. I'm looking for possible causes, not workarounds :-)
On Fri, Nov 26, 2010 at 8:57 PM, Prabhat Kumar wrote:
> Hi,
>
> to avoid this change ur "wait_timeout" value to 300 Secs or less, along
> with this you can als
Hi,
to avoid this change ur "wait_timeout" value to 300 Secs or less, along
with this you can also write a script to kill those process (mysql process)
which are in sleep mode for more than certain time..
hope this will helpful..
On Wed, Nov 24, 2010 at 6:41 PM, Johan De Meersman wrote:
> On
On Wed, Nov 24, 2010 at 1:13 PM, Nigel Wood wrote:
> Quick thought: what is your idle timeout set to on the MySQL server?
> Could you have configured it to reap these idle connections?
>
I could, probably, but the applications are generally well-behaved, and it's
not a recurring problem. I hope.
Seen this a lot with poorly written web apps which open connections but dont
close them when finished. Try setting wait_timeout and/or
interactive_timeout to close unused connections.
John
On 24 November 2010 11:27, Johan De Meersman wrote:
> Hey,
>
> Late last night, I got a call that one of
Hey,
Late last night, I got a call that one of our servers was down. Turns out
the machine had all 2500 connection slots in use, but none of them appeared
to be doing anything: hardly any CPU was being used, load 0.05, and tcpdump
confirmed that pretty much no data was being sent, either.
Disks w
