救命mysql占用cpu 100%

huayu

军哥，默认配置，mysql,没启用到InnoDB引擎
ps -eaf |grep mysql

1. root      2327     1  0 15:44 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mys
   
2. qld_safe --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/sls-ag16
   
3. p7.sea2.superbservers.com.pid
   
4. mysql     2430  2327 14 15:44 ?        00:38:33 /usr/local/mysql/libexec/mysqld
   
5. --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-err
   
6. or=/usr/local/mysql/var/sls-ag16p7.sea2.superbservers.com.err --pid-file=/usr/lo
   
7. cal/mysql/var/sls-ag16p7.sea2.superbservers.com.pid --socket=/tmp/mysql.sock --p
   
8. ort=3306
   
9. root     15345 25336  0 20:19 pts/1    00:00:00 grep mysql

复制代码

1. mysql> SHOW STATUS LIKE 'Table%';
   
2. +-----------------------+---------+
   
3. | Variable_name         | Value   |
   
4. +-----------------------+---------+
   
5. | Table_locks_immediate | 7380184 |
   
6. | Table_locks_waited    | 20015   |
   
7. +-----------------------+---------+
   
8. 2 rows in set (0.00 sec)

复制代码

mysql> show status;  字节过多，没办法发表，附件




[ 本帖最后由 huayu 于 2012-10-9 23:06 编辑 ]