Re: High MySQL sleep count

2010-06-01 Thread Raj Shekhar
In infinite wisdom Brent Clark wrote: > All servers are in datacentres. Im not 100% sure if its latency related, > but I see a load or SLEEP when I do mysqladin proc, which appears to be > hogging mysql. > > My question is. Would adjusting timeout values address this problem. The main causes

High MySQL sleep count

2010-05-26 Thread Brent Clark
Hiya I have a server that gets connections / requests from Germany and South Africa, Johannesburg (my server's based in Cape Town). All servers are in datacentres. Im not 100% sure if its latency related, but I see a load or SLEEP when I do mysqladin proc, which appears to be hogging mysql.