mysql访问60s出现timeout_SQL查询超时的设置方法(关于timeout的处理)

为了优化OceanBase的query timeout设置方式，特调研MySQL关于timeout的处理，记录如下。

复制代码 代码如下:

mysql> show variables like '%time%';

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

| Variable_name | Value |

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

| connect_timeout | 10 |

| datetime_format | %Y-%m-%d %H:%i:%s |

| delayed_insert_timeout | 300 |

| flush_time | 1800 |

| innodb_lock_wait_timeout | 50 |

| innodb_old_blocks_time | 0 |

| innodb_rollback_on_timeout | OFF |

| interactive_timeout | 28800 |

| lc_time_names | en_US |

| lock_wait_timeout | 31536000 |

| long_query_time | 10.000000 |

| net_read_timeout | 30 |

| net_write_timeout | 60 |

| slave_net_timeout | 3600 |

| slow_launch_time | 2 |

| system_time_zone | |

| time_format | %H:%i:%s |

| time_zone | SYSTEM |

| timed_mutexes | OFF |

| timestamp | 1366027807 |

| wait_timeout | 28800 |

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

21 rows in set, 1 warning (0.00 sec)

重点解释其中几个参数：

connect_timeout:

The number of seconds that the mysqld server waits for a connect packet before respondingwith Bad handshake. The default value is 10 seconds as