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小时
我觉得这种超时，不应刻意去修改参数，否则引起一些事务异常
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博客 ” ，链接：https://blog.itpub.net/807718/viewspace-2151868/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
MySQL 安全设置
请登录后发表评论
登录
全部评论
