2000在线服务器负载很高 看图

hfh08

2000在线服务器负载很高 看图

hfh08

mysql 占用很多 cpu

hfh08

SELECT m.uid,m.username,md.todaypost FROM pw_members m LEFT JOIN pw_memberdata md USING(uid) WHERE md.lastpost>'1186070400' ORDER BY md.todaypost DESC limit 0,10;
# User@Host: hao3gp_bbs[hao3gp_bbs] @ localhost []
# Query_time: 5  Lock_time: 0  Rows_sent: 10  Rows_examined: 1148702
SELECT m.uid,m.username,md.todaypost FROM pw_members m LEFT JOIN pw_memberdata md USING(uid) WHERE md.lastpost>'1186070400' ORDER BY md.todaypost DESC limit 0,10;
# User@Host: hao3gp_bbs[hao3gp_bbs] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 10  Rows_examined: 53049
SELECT tid,author,subject,replies,lastpost FROM pw_threads order by lastpost desc limit 0,10;
# Time: 070803 17:22:58
# User@Host: hao3gp_bbs[hao3gp_bbs] @ localhost []
# Query_time: 6  Lock_time: 0  Rows_sent: 10  Rows_examined: 1148702
SELECT m.uid,m.username,md.todaypost FROM pw_members m LEFT JOIN pw_memberdata md USING(uid) WHERE md.lastpost>'1186070400' ORDER BY md.todaypost DESC limit 0,10;
# User@Host: hao3gp_bbs[hao3gp_bbs] @ localhost []
# Query_time: 6  Lock_time: 0  Rows_sent: 10  Rows_examined: 1148702
SELECT m.uid,m.username,md.todaypost FROM pw_members m LEFT JOIN pw_memberdata md USING(uid) WHERE md.lastpost>'1186070400' ORDER BY md.todaypost DESC limit 0,10;
# User@Host: hao3gp_bbs[hao3gp_bbs] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 10  Rows_examined: 53049
SELECT tid,author,subject,replies,lastpost FROM pw_threads order by lastpost desc limit 0,10;
# Time: 070803 17:23:00
# User@Host: hao3gp_bbs[hao3gp_bbs] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 10  Rows_examined: 629
SELECT t.*,m.uid,m.username,m.gender, m.oicq, m.groupid,m.memberid,m.icon AS micon,m.hack,m.honor,m.signature,m.regdate,m.signchange,m.medals,m.showsign,m.payemail,md.postnum,md.digests,md.rvrc,md.money,md.credit,md.currency,md.thisvisit,md.onlinetime,md.starttime  FROM pw_posts t LEFT JOIN pw_members m ON m.uid=t.authorid LEFT JOIN pw_memberdata md ON md.uid=t.authorid  WHERE t.tid='3119' AND t.ifcheck='1' ORDER BY postdate LIMIT 239, 10;
# Time: 070803 17:23:02
# User@Host: hao3gp_bbs[hao3gp_bbs] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 10  Rows_examined: 1148702
SELECT m.uid,m.username,md.todaypost FROM pw_members m LEFT JOIN pw_memberdata md USING(uid) WHERE md.lastpost>'1186070400' ORDER BY md.todaypost DESC limit 0,10;
# Time: 070803 17:23:03
# User@Host: hao3gp_bbs[hao3gp_bbs] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 10  Rows_examined: 1148702
SELECT m.uid,m.username,md.todaypost FROM pw_members m LEFT JOIN pw_memberdata md USING(uid) WHERE md.lastpost>'1186070400' ORDER BY md.todaypost DESC limit 0,10;
# User@Host: hao3gp_bbs[hao3gp_bbs] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 10  Rows_examined: 1148702
SELECT m.uid,m.username,md.todaypost FROM pw_members m LEFT JOIN pw_memberdata md USING(uid) WHERE md.lastpost>'1186070400' ORDER BY md.todaypost DESC limit 0,10;
# Time: 070803 17:23:05

有比较多的这中日志

swordfish.cn

不知道楼主的什么配置，能说一下吗。好参考参考。