mysql cpu使用率超过100%,通过 show processlist;命令查询,里面有N条以下mysql查询代码,但是这个查询结果又没有任何实质内容,且单次查询结果为:317732 rows in set (5.75 sec)
SELECT p.fid,p.tid,p.pid,f.name,t.subject,p.message,p.dateline,p.authorid, p.author FROM pre_forum_thread t, pre_forum_forum f, pre_forum_post p where f.status<>'3' AND f.fid=t.fid AND t.tid=p.tid AND t.displayorder not IN(-1,-2) and p.subject='' ORDER BY p.dateline DESC;