- 论坛徽章:
- 0
|
刚刚突然间慢下来
我show processlist 看了一下
主要如下
mysql> show processlist;
+------+-----------+-----------+------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-----------+-----------+------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 185 | szxnmysql | localhost | szxndiscuz | Query | 0 | NULL | show processlist |
| 3075 | szxnmysql | localhost | szxndiscuz | Sleep | 256 | | NULL |
| 3304 | szxnmysql | localhost | szxndiscuz | Query | 33 | Copying to tmp table | SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN |
| 3307 | szxnmysql | localhost | szxndiscuz | Query | 32 | Copying to tmp table | SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN |
| 3318 | szxnmysql | localhost | szxndiscuz | Query | 24 | Sorting result | SELECT p.*,m.username,m.adminid,m.groupid,m.credits FROM cdb_posts p LEFT JOIN cdb_members m ON m.ui |
| 3328 | szxnmysql | localhost | szxndiscuz | Query | 19 | Locked | UPDATE cdb_threads SET lastposter='??????', lastpost='1217084339', replies=replies+1 , subscribed='0 |
| 3330 | szxnmysql | localhost | szxndiscuz | Query | 17 | Locked | SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN |
| 3331 | szxnmysql | localhost | szxndiscuz | Query | 15 | Locked | SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN |
| 3335 | szxnmysql | localhost | szxndiscuz | Query | 13 | Locked | SELECT t.tid, t.closed, t.dateline, t.special, t.lastpost AS lastthreadpost, f.*, ff.* , f.fid AS |
| 3336 | szxnmysql | localhost | szxndiscuz | Query | 13 | Locked | SELECT t.tid, t.closed, t.dateline, t.special, t.lastpost AS lastthreadpost, f.*, ff.* , f.fid AS |
| 3337 | szxnmysql | localhost | szxndiscuz | Query | 11 | Locked | SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN |
| 3339 | szxnmysql | localhost | szxndiscuz | Query | 9 | Locked | SELECT t.* FROM cdb_threads t
WHERE t.tid IN (3366,24640,29321,28806) AND t.displayorder IN (2, 3 |
| 3340 | szxnmysql | localhost | szxndiscuz | Query | 10 | Locked | SELECT t.tid, t.closed, t.dateline, t.special, t.lastpost AS lastthreadpost, f.*, ff.* , f.fid AS |
| 3342 | szxnmysql | localhost | szxndiscuz | Query | 9 | Locked | SELECT t.tid, t.closed, t.dateline, t.special, t.lastpost AS lastthreadpost, f.*, ff.* , f.fid AS |
| 3343 | szxnmysql | localhost | szxndiscuz | Query | 8 | Locked | UPDATE cdb_members SET credits='784' WHERE uid='910' |
| 3347 | szxnmysql | localhost | szxndiscuz | Query | 3 | Locked | SELECT t.tid, t.closed, t.dateline, t.special, t.lastpost AS lastthreadpost, f.*, ff.* , f.fid AS |
| 3348 | szxnmysql | localhost | szxndiscuz | Query | 2 | Locked | SELECT t.tid, t.closed, t.dateline, t.special, t.lastpost AS lastthreadpost, f.*, ff.* , f.fid AS |
| 3349 | szxnmysql | localhost | uchome | Query | 1 | update | INSERT INTO uchome_log (`id`, `idtype`) VALUES ('865', 'uid') |
+------+-----------+-----------+------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
18 rows in set (0.00 sec)
mysql> show processlist;
+------+-----------+-----------+------------+---------+------+-------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-----------+-----------+------------+---------+------+-------------------+------------------------------------------------------------------------------------------------------+
| 185 | szxnmysql | localhost | szxndiscuz | Query | 0 | NULL | show processlist |
| 3075 | szxnmysql | localhost | szxndiscuz | Sleep | 280 | | NULL |
| 3330 | szxnmysql | localhost | szxndiscuz | Query | 41 | Sorting for group | SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN |
| 3331 | szxnmysql | localhost | szxndiscuz | Query | 39 | Sorting for group | SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN |
| 3337 | szxnmysql | localhost | szxndiscuz | Query | 35 | Sorting for group | SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN |
| 3354 | szxnmysql | localhost | szxndiscuz | Query | 12 | Sending data | SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestpos |
| 3361 | szxnmysql | localhost | szxndiscuz | Query | 8 | Locked | UPDATE cdb_members SET newpm='0' WHERE uid='910' |
| 3362 | szxnmysql | localhost | szxndiscuz | Query | 5 | Locked | SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestpos |
| 3363 | szxnmysql | localhost | szxndiscuz | Query | 5 | Locked | SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestpos |
| 3364 | szxnmysql | localhost | szxndiscuz | Query | 4 | Locked | SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestpos |
| 3366 | szxnmysql | localhost | szxndiscuz | Query | 4 | Locked | SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestpos |
| 3368 | szxnmysql | localhost | szxndiscuz | Sleep | 1 | | NULL |
| 3370 | szxnmysql | localhost | szxndiscuz | Query | 1 | Locked | SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestpos |
| 3371 | szxnmysql | localhost | szxndiscuz | Sleep | 1 | | NULL |
| 3372 | szxnmysql | localhost | szxndiscuz | Query | 1 | Locked | SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestpos |
+------+-----------+-----------+------------+---------+------+-------------------+------------------------------------------------------------------------------------------------------+
15 rows in set (0.00 sec) |
|