How to change timeout for mysql persistent connections to keep alive
mysql> SHOW VARIABLES LIKE '%_timeout';
Result shows 28800 (i.e. 8 hours), which is the default wait_timout.
mysql> SET SESSION wait_timeout = 86400; // 1 day. Maximum is 24.8 Days.
mysql> SET SESSION interactive_timeout = 86400; // 1 day. Maximum is 24.8 Days.
mysql> SHOW PROCESSLIST
wait_timeout is the amount of seconds during inactivity that MySQL will wait before it will close a connection on a non-interactive connection.
interactive_timeout is the same, but for interactive sessions (mysql shell)
Tuesday, August 21, 2012
Subscribe to:
Posts (Atom)