一些MySQL的错误skip-name-resolve

johncan

[root@db1 ~]# service mysqld status
mysqld (pid 2965) is running...
[root@db1 ~]# service mysqld restart
Timeout error occurred trying to stop MySQL Daemon.
Stopping MySQL:                                            [FAILED]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]
[root@db1 ~]# cd /var/log/
[root@db1 log]# tail mysqld.log

090326 10:59:56 [Warning] /usr/libexec/mysqld: Forcing close of thread 9  user: ''

090326 10:59:56 [Warning] /usr/libexec/mysqld: Forcing close of thread 8  user: ''

090326 10:59:56 [Warning] /usr/libexec/mysqld: Forcing close of thread 7  user: ''

090326 10:59:56 [Warning] /usr/libexec/mysqld: Forcing close of thread 6  user: ''

A mysqld process already exists at  Thu Mar 26 11:00:54 CST 2009
[root@db1 log]# service mysqld status
mysqld dead but subsys locked
mysql> show processlist;
+----+----------------------+--------------------+------+---------+------+-------+------------------+
| Id | User                 | Host               | db   | Command | Time | State | Info             |
+----+----------------------+--------------------+------+---------+------+-------+------------------+
| 24 | unauthenticated user | 192.168.100.123:46053 | NULL | Connect |      | login | NULL             |
| 25 | unauthenticated user | 192.168.100.123:46061 | NULL | Connect |      | login | NULL             |
| 26 | unauthenticated user | 192.168.100.123:46063 | NULL | Connect |      | login | NULL             |
| 27 | unauthenticated user | 192.168.100.123:46067 | NULL | Connect |      | login | NULL             |
| 28 | unauthenticated user | 192.168.100.123:46069 | NULL | Connect |      | login | NULL             |
| 29 | unauthenticated user | 192.168.100.123:46071 | NULL | Connect |      | login | NULL             |
| 30 | unauthenticated user | 192.168.100.123:46073 | NULL | Connect |      | login | NULL             |
| 31 | unauthenticated user | 192.168.100.123:46074 | NULL | Connect |      | login | NULL             |
| 32 | unauthenticated user | 192.168.100.123:46080 | NULL | Connect |      | login | NULL             |
| 33 | unauthenticated user | 192.168.100.123:46095 | NULL | Connect |      | login | NULL             |
| 34 | unauthenticated user | 192.168.100.123:46097 | NULL | Connect |      | login | NULL             |
| 35 | root                 | localhost          | NULL | Query   |    0 | NULL  | show processlist |
| 36 | unauthenticated user | 192.168.100.123:46102 | NULL | Connect |      | login | NULL             |
+----+----------------------+--------------------+------+---------+------+-------+------------------+
13 rows in set (0.00 sec)
ERROR 1040 (00000): Too many connections
The user root is able to execute the following statements: 'SHOW GLOBAL STATUS', 'SHOW SLAVE STATUS' (minimal privileges needed: SELECT, REPLICATION CLIENT)
不知道是不是那天我把SNAT关掉，然后导致数据库无法查询到域名的缘故，从客户端连接数据库很慢，偶尔可以连上并读出数据，但刷新页面又出错，以上是处理问题时出现的一些错误，不知道是在哪篇文章看到的，说
vi /etc/my.cnf
加入：
skip-name-resolve
这样，service mysqld restart就很快执行了！连接问题也得到解决！


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/17993/showart_1882642.html