error_log 产生很多错误 Aborted connection 4 to db

2018-03-13T14:37:02.125332Z 4 [Note] Aborted connection 4 to db: 'gkgpv2' user: 'admin' host: 'tqsrv131-git' (Got timeout reading communication packets)
2018-03-13T14:37:03.414265Z 6 [Note] Aborted connection 6 to db: 'gkgpv2' user: 'admin' host: 'tqsrv131-git' (Got timeout reading communication packets)
2018-03-13T14:37:04.564853Z 7 [Note] Aborted connection 7 to db: 'gkgpv2' user: 'admin' host: 'tqsrv131-git' (Got timeout reading communication packets)
2018-03-13T14:37:05.554168Z 8 [Note] Aborted connection 8 to db: 'gkgpv2' user: 'admin' host: 'tqsrv131-git' (Got timeout reading communication packets)
2018-03-13T14:37:06.694751Z 9 [Note] Aborted connection 9 to db: 'gkgpv2' user: 'admin' host: 'tqsrv131-git' (Got timeout reading communication packets)
2018-03-13T14:37:07.451528Z 10 [Note] Aborted connection 10 to db: 'gkgpv2' user: 'admin' host: 'tqsrv131-git' (Got timeout reading communication packets)
2018-03-13T14:37:08.513545Z 11 [Note] Aborted connection 11 to db: 'gkgpv2' user: 'admin' host: 'tqsrv131-git' (Got timeout reading communication packets)
2018-03-13T14:37:09.352800Z 12 [Note] Aborted connection 12 to db: 'gkgpv2' user: 'admin' host: 'tqsrv131-git' (Got timeout reading communication packets)
2018-03-13T14:37:10.353704Z 13 [Note] Aborted connection 13 to db: 'gkgpv2' user: 'admin' host: 'tqsrv131-git' (Got timeout reading communication packets)
2018-03-13T14:37:11.571591Z 14 [Note] Aborted connection 14 to db: 'gkgpv2' user: 'admin' host: 'tqsrv131-git' (Got timeout reading communication packets)
2018-03-13T14:37:12.417176Z 15 [Note] Aborted connection 15 to db: 'gkgpv2' user: 'admin' host: 'tqsrv131-git' (Got timeout reading communication packets)


mysql> show variables like '%timeout%';
+-----------------------------+----------+
| Variable_name               | Value    |
+-----------------------------+----------+
| connect_timeout             | 10       |
| delayed_insert_timeout      | 300      |
| have_statement_timeout      | YES      |
| 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           | 60       |
| wait_timeout                | 28800    |
+-----------------------------+----------+
13 rows in set (0.01 sec)

8小时

我觉得这种超时，不应刻意去修改参数，否则引起一些事务异常

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/807718/viewspace-2151868/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/807718/viewspace-2151868/