mysql 错误日志:Got an error reading communication packets

最新推荐文章于 2024-03-12 10:55:59 发布

helloxielan

最新推荐文章于 2024-03-12 10:55:59 发布

阅读量4.6k

点赞数

文章标签：数据库操作系统 python

原文链接：https://my.oschina.net/AnnaWu/blog/1592698

版权

为什么80%的码农都做不了架构师？>>>

Mysql 错误日志中突然发现大量的Got an error reading communication packets

grep "Got an error reading communication packets" error_log_3356.err |wc -l

360

比较基线的参数文件，发现log_warnings有变化

mysql> select @@log_warnings;
+----------------+
| @@log_warnings |
+----------------+
|              2 |
+----------------+
1 row in set (0.00 sec)

mysql> set global log_warnings=0;
Query OK, 0 rows affected (0.00 sec)



mysql> select @@log_warnings;
+----------------+
| @@log_warnings |
+----------------+
|              0 |
+----------------+
1 row in set (0.00 sec)

官方文档对log_warnings的解释

Print out warnings such as Aborted connection... to the error log. This option is enabled (1) by default. To disable it, use --log-warnings=0. Specifying the option without a level value increments the current value by 1. Enabling this option by setting it greater than 0 is recommended, for example, if you use replication (you get more information about what is happening, such as messages about network failures and reconnections). If the value is greater than 1, aborted connections are written to the error log, and access-denied errors for new connection attempts are written

http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_log-warnings

转载于:https://my.oschina.net/AnnaWu/blog/1592698