首页 » 互联网资讯 » 正文

救命mysql占用cpu 100%

默认配置,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)

————————————————————————————————————————-

发表评论