阿里云mysql日志分析_mySQL 错误日志分析-阿里云开发者社区

错误：

130111  3:33:55 [Warning] IP address '74.86.110.133' has been resolved to the host name '74.86.110.133-static.reverse.softlayer.com', which resembles IPv4-address itself.

130111  4:00:00 [Note] /usr/sbin/mysqld: Normal shutdown

130111  4:00:00 [Note] Event Scheduler: Purging the queue. 0 events

130111  4:00:02 [Warning] /usr/sbin/mysqld: Forcing close of thread 410210  user: 'root'

SET GLOBAL max_connect_errors=10000;

错误日志有类似警告：

120119 16:26:04 [Warning] IP address '192.168.0.110' could not be resolved: Name or service not known

120119 16:26:04 [Warning] IP address '192.168.0.104' could not be resolved: Name or service not known

120119 16:26:04 [Warning] IP address '192.168.0.147' could not be resolved: Name or service not known

通过show processlist发现大量类似如下的连接：

|592|unauthenticate