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.

Back

Layout Copyright © 2006 Finnish Teleservice Center Ltd Oy - Site Powered by Midgard CMS