求救，MYSQL线程不断增加。。。

我的服务器是装的centos + apache + php + mysql

平时使用是正常，但偶尔会出现mysql线程不断增加的情况，一旦开始出现这个情况，论坛就无法正常访问了。

mysql线程会一直增加直到死机。

以前出的少也没太在意，昨天装了个首页 4格缓存 就开始频繁出现这个问题了，高手帮忙看看什么问题。

线程开始增加的时候CPU占用也不算高，但所有服务响应都会变慢。

大家帮忙

There seems to have been a problem with the database of your Discuz! Board

Discuz! info: Can not connect to MySQL server

Time: 2008-6-1 1:33pm
Script: /viewthread.php

Error:  Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Errno.:  2002

Please check-up your MySQL server and forum scripts, similar errors will not be reported again in recent 24 hours
If you have troubles in solving this problem, please visit Discuz! Community http://www.Discuz.net.




There seems to have been a problem with the database of your Discuz! Board

Discuz! info: MySQL Query Error

User: 心路
Time: 2008-6-1 1:33pm
Script: /forumdisplay.php

SQL: SELECT t.tid,t.fid,t.readperm,t.author,t.authorid,t.subject,t.dateline,t.lastpost,t.lastposter,t.views,t.replies,t.highlight,t.digest,t.typeid
                        FROM `cdb_threads` t WHERE t.readperm='0'
                         AND t.dateline>=1212207642
                        AND t.displayorder>='0'
                        AND t.fid>'0'
                       
                        ORDER BY t.views DESC
                        LIMIT 0,10;
Error:  Sort aborted
Errno.:  1028

Please check-up your MySQL server and forum scripts, similar errors will not be reported again in recent 24 hours
If you have troubles in solving this problem, please visit Discuz! Community http://www.Discuz.net.


There seems to have been a problem with the database of your Discuz! Board

Discuz! info: MySQL Query Error

Time: 2008-6-1 1:33pm
Script: /redirect.php

SQL: UPDATE LOW_PRIORITY cdb_threads SET views=views+1 WHERE tid='101767'
Error:  Server shutdown in progress
Errno.:  1053

Please check-up your MySQL server and forum scripts, similar errors will not be reported again in recent 24 hours
If you have troubles in solving this problem, please visit Discuz! Community http://www.Discuz.net.

[ 本帖最后由 185 于 2008-6-1 14:55 编辑 ]

基本上都是出现上面的错误。

[ 本帖最后由 185 于 2008-6-1 14:52 编辑 ]

出现问题的时候看MYSQL的进程是在执行什么查询

弱弱问一句，怎么看啊？

phpmyadmin进程里可以看到
命令行下用 mysqladmin -uroot -p processlist 可以看到

谁说的，不支持

我只要装上4格或5格，不论是不是缓存版，工作一段时间后系统进程都为疯狂增加，主要是APACHE和mysql进程增加，最后机器越来越慢，WEB无法打开。
替换index.php和discuz.htm回原文件后，重新启动mysql，一切又会正常，这会是什么问题了，请帮我分析下，谢谢。