When MySQL goes away
Posted on 2009-03-18 11:47:17 EET.
I am debugging Midgard problem related to MySQL 2006 error. It's well known as "MySQL server has gone away". What I found so far, is an easy way to set very short timeout for debugging purposes. I execute such query in MySQL shell (and it sets timeout for 15 seconds):
set global wait_timeout = 15;
Similarly, you set increase yout timeout if sercer times out too quickly:
set global wait_timeout = 86400;
This one sets timeout for 24 hours.
Once you do so, you can notice different values when executing show variables query. Do not worry, the query you used, returns variables from the session you are just running.