Tuesday 18 December 2012

MySQL connections don't reconnect after idle timeout

Tthis is a workaround I use and it works for me.

for explanations of the options below.

in /etc/my.cnf you can add this…
# vim /etc/my.cnf

# 3 day timeout in seconds
 

[mysqld] 

wait_timeout=259200


interactive_timeout=259200

The default value for wait_timeout is 28800 which is 8 hours.
 

wait_timeout is for connections from TCP/IP.

I also found this.

Note:The suggested fix would be to trap error 2006 and immediately attempt to reconnect to the database. 

 

1 comment: