救命mysql占用cpu 100%
军哥，默认配置，mysql,没启用到InnoDB引擎ps -eaf |grep mysqlroot 2327 10 15:44 ? 00:00:00 /bin/sh /usr/local/mysql/bin/mys
qld_safe --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/sls-ag16
p7.sea2.superbservers.com.pid
mysql 24302327 14 15:44 ? 00:38:33 /usr/local/mysql/libexec/mysqld
--basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-err
or=/usr/local/mysql/var/sls-ag16p7.sea2.superbservers.com.err --pid-file=/usr/lo
cal/mysql/var/sls-ag16p7.sea2.superbservers.com.pid --socket=/tmp/mysql.sock --p
ort=3306
root 15345 253360 20:19 pts/1 00:00:00 grep mysqlmysql> SHOW STATUS LIKE 'Table%';
+-----------------------+---------+
| Variable_name | Value |
+-----------------------+---------+
| Table_locks_immediate | 7380184 |
| Table_locks_waited | 20015 |
+-----------------------+---------+
2 rows in set (0.00 sec)
mysql> show status;字节过多，没办法发表，附件
[ 本帖最后由 huayu 于 2012-10-9 23:06 编辑 ]
页:
[1]