这里的高手帮心看看。为什么会有这么多mysql进程

Question

VPS 是xen hvm，系统是cs 4.8服务器版, 用的是lnmp1.0[root@204 ~]# ps -ef|grep mysqlroot     17680     1  0 16:14 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid
mysql    17786 17680  0 16:14 ?        00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    17787 17786  0 16:14 ?        00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    17788 17787  0 16:14 ?        00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18225 17787  0 17:56 ?        00:00:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18226 17787  0 17:56 ?        00:00:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18227 17787  0 17:56 ?        00:00:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18228 17787  0 17:56 ?        00:00:02 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18229 17787  0 17:56 ?        00:00:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18230 17787  0 17:56 ?        00:00:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18231 17787  0 17:56 ?        00:00:02 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18232 17787  0 17:56 ?        00:00:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18233 17787  0 17:56 ?        00:00:02 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18235 17787  0 17:56 ?        00:00:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18236 17787  0 17:56 ?        00:00:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18237 17787  0 17:56 ?        00:00:02 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18238 17787  0 17:56 ?        00:00:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18239 17787  0 17:57 ?        00:00:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18243 17787  0 17:57 ?        00:00:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
mysql    18247 17787  0 17:58 ?        00:00:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/201.static.quadranet.com.err --pid-file=/usr/local/mysql/var/201.static.quadranet.com.pid --socket=/tmp/mysql.sock --port=3306
root     18493 18120  0 18:56 pts/1    00:00:00 grep mysql
[root@204 ~]# 执行top18385 www       15   0 17128  12m  896 S  0.0  1.2   0:02.60 nginx                                                                                                                
17786 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:00.00 mysqld                                                                                                               
17787 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:00.01 mysqld                                                                                                               
17788 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:00.00 mysqld                                                                                                               
18225 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:03.06 mysqld                                                                                                               
18226 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:03.45 mysqld                                                                                                               
18227 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:04.01 mysqld                                                                                                               
18228 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:03.73 mysqld                                                                                                               
18229 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:03.44 mysqld                                                                                                               
18230 mysql     17   0 35028  11m 2812 S  0.0  1.2   0:03.63 mysqld                                                                                                               
18231 mysql     16   0 35028  11m 2812 S  0.3  1.2   0:04.59 mysqld                                                                                                               
18232 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:03.96 mysqld                                                                                                               
18233 mysql     17   0 35028  11m 2812 S  0.0  1.2   0:04.17 mysqld                                                                                                               
18235 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:04.81 mysqld                                                                                                               
18236 mysql     17   0 35028  11m 2812 S  0.0  1.2   0:03.62 mysqld                                                                                                               
18237 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:03.77 mysqld                                                                                                               
18238 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:04.45 mysqld                                                                                                               
18239 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:03.03 mysqld                                                                                                               
18243 mysql     17   0 35028  11m 2812 S  0.0  1.2   0:03.64 mysqld                                                                                                               
18247 mysql     16   0 35028  11m 2812 S  0.0  1.2   0:04.05 mysqld                                                                                                               
18384 www       15   0 16360  11m  896 S  0.0  1.2   0:00.97 nginx  

Answer 1

[root@204 ~]# free
             total       used       free     shared    buffers     cached
Mem:       1034600     947392      87208          0      59768     733048
-/+ buffers/cache:     154576     880024
Swap:      2031608        184    2031424

Answer 2

看这个 --log-error=/usr/local/mysql/var/201.static.quadranet.com.err错误里面有什么
看看磁盘空间还有吗  应该是磁盘空间不足导致mysql不停重启

Answer 3

磁盘空间是不是用df命令。[root@204 ~]# df
Filesystem             1K-块        已用     可用 已用% 挂载点
/dev/mapper/VolGroup00-LogVol00
                      28834812   2680440  24689644  10% /
/dev/hda1               101086     20082     75785  21% /boot
none                    517300         0    517300   0% /dev/shm
[root@204 ~]# 

Answer 4

120117 09:29:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120117  9:29:08 [ERROR] Fatal error: Can't open and lock privilege tables: File './mysql/user.MYD' not found (Errcode: 13)
120117 09:29:08 mysqld_safe mysqld from pid file /usr/local/mysql/var/201.static.quadranet.com.pid ended
120117 09:30:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120117  9:30:12 [ERROR] Fatal error: Can't open and lock privilege tables: File './mysql/user.MYD' not found (Errcode: 13)
120117 09:30:12 mysqld_safe mysqld from pid file /usr/local/mysql/var/201.static.quadranet.com.pid ended
120117 09:30:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120117  9:30:39 [ERROR] Fatal error: Can't open and lock privilege tables: File './mysql/user.MYD' not found (Errcode: 13)
120117 09:30:39 mysqld_safe mysqld from pid file /usr/local/mysql/var/201.static.quadranet.com.pid ended
120117 09:30:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120117  9:30:57 [ERROR] Fatal error: Can't open and lock privilege tables: File './mysql/user.MYD' not found (Errcode: 13)
120117 09:30:57 mysqld_safe mysqld from pid file /usr/local/mysql/var/201.static.quadranet.com.pid ended
120117 09:31:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120117  9:31:39 [Note] Event Scheduler: Loaded 0 events
120117  9:31:39 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120117  9:33:14 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown120117  9:33:14 [Note] Event Scheduler: Purging the queue. 0 events
120117  9:33:14 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete120117 09:33:14 mysqld_safe mysqld from pid file /usr/local/mysql/var/201.static.quadranet.com.pid ended
120117 09:33:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120117  9:33:31 [ERROR] Fatal error: Can't open and lock privilege tables: File './mysql/user.MYD' not found (Errcode: 13)
120117 09:33:31 mysqld_safe mysqld from pid file /usr/local/mysql/var/201.static.quadranet.com.pid ended
120117 09:33:51 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120117  9:33:51 [ERROR] Fatal error: Can't open and lock privilege tables: File './mysql/user.MYD' not found (Errcode: 13)
120117 09:33:51 mysqld_safe mysqld from pid file /usr/local/mysql/var/201.static.quadranet.com.pid ended
120117 09:39:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120117  9:39:32 [ERROR] Column count of mysql.event is wrong. Expected 22, found 18. Created with MySQL 50120, now running 50160. Please use mysql_upgrade to fix this error.
120117  9:39:32 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
120117  9:39:32 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120117  9:50:59 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown120117  9:50:59 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete120117 09:50:59 mysqld_safe mysqld from pid file /usr/local/mysql/var/201.static.quadranet.com.pid ended
120117 09:53:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120117  9:53:12 [Note] Event Scheduler: Loaded 0 events
120117  9:53:12 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120117 16:08:09 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown120117 16:08:09 [Note] Event Scheduler: Purging the queue. 0 events
120117 16:08:10 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete120117 16:08:10 mysqld_safe mysqld from pid file /usr/local/mysql/var/201.static.quadranet.com.pid ended
120117 16:08:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120117 16:08:11 [Note] Event Scheduler: Loaded 0 events
120117 16:08:11 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120117 16:14:22 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown120117 16:14:22 [Note] Event Scheduler: Purging the queue. 0 events
120117 16:14:24 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete120117 16:14:24 mysqld_safe mysqld from pid file /usr/local/mysql/var/201.static.quadranet.com.pid ended
120117 16:14:25 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120117 16:14:25 [Note] Event Scheduler: Loaded 0 events
120117 16:14:25 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

Answer 5

不明白，我倒是遇到过磁盘空间满了以后，杀不掉mysql进程。得-9。能杀就杀了重启下看看。

Answer 6

从你的错误日志来看，MYSQL已经正常启动了。