暂无图片
MySQL 5.7.13 Aborted_clients 持续增加 日志频繁报 Got timeout reading communication packets)
我来答
分享
手机用户0537
2020-05-01
MySQL 5.7.13 Aborted_clients 持续增加 日志频繁报 Got timeout reading communication packets)

[Note] Aborted connection 334575338 to db: ‘xxxdb’ user: ‘xxuser’ host: ‘192.168.0.99’ (Got timeout reading communication packets)

mysql> show global status like ‘aborted%’;
±-----------------±--------+
| Variable_name | Value |
±-----------------±--------+
| Aborted_clients | 4479055 |
| Aborted_connects | 61061 |
±-----------------±--------+
2 rows in set (0.00 sec)

Aborted_clients 持续增大,Aborted_connects 无变化.

相关参数如下: 改如何改进?
mysql> show variables like ‘%timeout%’;
±----------------------------±---------+
| Variable_name | Value |
±----------------------------±---------+
| connect_timeout | 20 |
| 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 | 90 |
| net_write_timeout | 180 |
| rpl_stop_slave_timeout | 31536000 |
| slave_net_timeout | 60 |
| wait_timeout | 28800 |
±----------------------------±---------+
13 rows in set (0.01 sec)

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
Cui Hulong

可参考以下内容:
https://www.modb.pro/db/23585

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏