[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就很快执行了！连接问题也得到解决！