passt 发表于 2011-11-20 20:54:22

mysql大量错误

centos lnmp0.6，另一台服务器远程连接这个mysql，重启后出现大量这个错误，不能连接

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 821user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 820user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 819user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 818user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 817user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 816user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 815user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 814user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 813user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 812user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 811user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 810user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 809user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 808user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 807user: ''

111120 13:13:56 /usr/local/mysql/libexec/mysqld: Forcing close of thread 806user: '

passt 发表于 2011-11-20 22:24:03

解决了

原因是mysql的反向解析连接使中断或者变慢
my.cny里加上
skip-name-resolve
重启mysql
:victory::lol
页: [1]
查看完整版本: mysql大量错误