[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)
墨值悬赏

评论
