一些MySQL的错误skip-name-resolve

[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关掉，然后导致数据库无法查询到域名的缘故，从客户端连接数据库很慢，偶尔可以连上并读出数据，但刷新页面又出错，以上是处理问题时出现的一些错误，不知道是在哪篇文章看到的，说<meta name="ProgId" content="OneNote.File"><meta name="Generator" content="Microsoft OneNote 11">

vi /etc/my.cnf

加入：

skip-name-resolve

这样，service mysqld restart就很快执行了！连接问题也得到解决！