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.

My question is. Would adjusting timeout values address this problem.

I was thinking of using / setting these values.
[mysqld]
set-variable    = connect_timeout=20
set-variable    = wait_timeout=20
set-variable    = interactive_timeout=20
set-variable    = net_write_timeout=20

Can anyone share some thought or opinion on this. Or whats the correct practice.

Kind Regards
Brent Clark





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to