MySQL 5.6 for timeout parameters

MySQL 5.6 for timeout parameters

Mysql> show global variables like '%timeout% ';

+-----------------------------+----------+

| variable_name | Value |

+-----------------------------+----------+

| Connect_timeout | 1000 |

| Delayed_insert_timeout | 300 |

| Innodb_flush_log_at_timeout | 1 |

| Innodb_lock_wait_timeout | 50 |

| Innodb_rollback_on_timeout | OFF |

| Interactive_timeout | 28800 |

| Lock_wait_timeout | 31536000 |

| Net_read_timeout | 30 |

| Net_write_timeout | 60 |

| Rpl_stop_slave_timeout | 31536000 |

| Slave_net_timeout | 3600 |

| Wait_timeout | 28800 |

+-----------------------------+----------+

Connect_timeout: Link timeout, the user login to verify the identity of the user is valid, if the network is not good, the parameter can be slightly larger, on the one hand can

Extend authentication time, increase the probability of a user's login success, and, on the other hand, prevent the number of connections from exploding beyond the maximum limit. By default, this value is 10s.

The setting for this value is rather large, not too small.

Innodb_lock_wait_timeout: Lock wait Timeout, default value is 50s, this value is the default, if due to a large number of lock waits timeout, may check the next SQL statement or index.

Lock_wait_timeout:

Interactive_timeout/wait_timeout: Time-out settings for interactive and non-interactive links, preventing clients from linking to databases for long periods of time, doing nothing

In the sleep state, forces the long sleep link to close. By default, both values are 28800 (8h), and the two value is normally set to 1000s.

Net_read_timeout/net_write_timeout: The client writes the data/data receive timeout setting, which is the default line.

Delayed_insert_timeout: This is a time-out parameter designed for MyISAM insert delay, which waits for the INSERT statement before the Insert delay aborts.

Innodb_flush_log_at_timeout: Transaction log refresh interval, default is 1s,5.6 new!. Refer to the following: http://www.xuchanggang.cn/archives/567.html

Slave_net_timeout: This is the slave to determine whether the host hangs out of the timeout setting, in the set time still do not get the master response to think that master hung off

Rpl_stop_slave_timeout: Control the execution time of Stop slave, when replay a large transaction, suddenly execute stop slave,

The command stop slave will execute for a long time, this time may produce deadlock or blocking, severely affect performance, MySQL 5.6 can be rpl_stop_slave_timeout

Parameters control the execution time of the Stop Slave,

Summary: The above parameters, the individual feel more important to have

Connect_timeout: Authentication Timeout

Innodb_lock_wait_timeout: Waiting timeout

Interactive_timeout\wait_timeout: Idle link timeout

RELATED links:

Http://www.cnblogs.com/jiunadianshi/articles/2475475.html

Http://www.itpub.net/thread-1308603-1-1.html

http://wangwei.cao.blog.163.com/blog/static/10236252620111119115540534/

This article is from the "SQL Server MySQL" blog, so be sure to keep this source http://dwchaoyue.blog.51cto.com/2826417/1575813

MySQL 5.6 for timeout parameters