[Warning] Aborted connection问题探究

错误日志显示：130615 10:29:28 [Warning] Aborted connection 69 to db: 'studd' user: 'user1' host: '...

错误日志显示：
130615 10:29:28 [Warning] Aborted connection 69 to db: 'studd' user: 'user1' host: '192.158.22.22' (Got an error reading communication packets)

mysql> show global variables like '%log_warning%';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| log_warnings  | 2     |

+---------------+-------+

1 row in set (0.00 sec)

其实也没什么大碍, 只是警告提示而已, 是由于把mysqld的参数log_warnings参数设置成2了(默认是1). 

对于告警日志, 第一条应该是PHP脚本中未mysql_close()所以有这个告警, 通过设置wait_timeout为60秒后, 这种未正常关闭的连接sleep后自动关闭;

set @@global.log_warnings=1;