- 论坛徽章:
- 0
|
top - 00:03:05 up 4 days, 6:34, 2 users, load average: 1.29, 0.73, 0.64
Tasks: 111 total, 1 running, 110 sleeping, 0 stopped, 0 zombie
Cpu(s): 9.1% us, 7.0% sy, 0.0% ni, 35.5% id, 46.5% wa, 1.9% hi, 0.0% si
Mem: 969608k total, 192640k used, 776968k free, 1260k buffers
Swap: 11582856k total, 74788k used, 11508068k free, 50264k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21050 mysql 15 0 325m 29m 2272 D 8.9 3.1 0:13.66 mysqld
22610 nobody 17 0 21308 5612 1904 S 3.3 0.6 0:00.21 httpd
22574 nobody 15 0 22424 6880 1956 S 3.0 0.7 0:01.25 httpd
22583 nobody 16 0 22572 6980 1948 S 3.0 0.7 0:00.95 httpd
22592 nobody 16 0 22640 7008 1952 S 3.0 0.7 0:00.82 httpd
22532 nobody 16 0 22612 7024 1944 S 2.3 0.7 0:01.56 httpd
21875 mysql 15 0 325m 29m 2272 D 1.0 3.1 0:03.14 mysqld
22564 root 16 0 3268 964 752 R 0.7 0.1 0:00.80 top
1904 root 16 0 2120 272 236 S 0.3 0.0 0:59.02 cpuspeed
20537 mysql 15 0 325m 29m 2272 D 0.3 3.1 0:09.27 mysqld
22560 nobody 15 0 21292 5564 1896 S 0.3 0.6 0:00.17 httpd
22567 nobody 16 0 22520 6956 1948 S 0.3 0.7 0:01.04 httpd
1 root 16 0 3220 264 244 S 0.0 0.0 0:22.23 init
2 root RT 0 0 0 0 S 0.0 0.0 0:03.41 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:05.66 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:12.49 migration/1
5 root 35 19 0 0 0 S 0.0 0.0 0:20.60 ksoftirqd/1
这是刚才有一次的
mysql> show full processlist;
+------+-----------+-----------+------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-----------+-----------+------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 185 | szxnmysql | localhost | szxndiscuz | Query | 0 | NULL | show full processlist |
| 7360 | szxnmysql | localhost | szxndiscuz | Query | 17 | Copying to tmp table | SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN cdb_threads t ON t.tid=attach.tid WHERE attach.readperm='0' AND displayorder>='0' AND filetype like 'image/%g%' GROUP BY attach.tid ORDER BY attach.dateline DESC LIMIT 0, 50 |
| 7365 | szxnmysql | localhost | szxndiscuz | Query | 1 | Sending data | SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,
m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6,
m.extcredits7, m.extcredits8, m.email, m.gender, m.showemail, m.invisible, mf.nickname, mf.site,
mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.fromcity, mf.fromtown, mf.nowcity, mf.nowtown, mf.medals,
mf.sightml AS signature, mf.customstatus, mf.spacename
FROM cdb_posts p
LEFT JOIN cdb_members m ON m.uid=p.authorid
LEFT JOIN cdb_memberfields mf ON mf.uid=m.uid
WHERE p.tid='19855' AND p.invisible='0' ORDER BY dateline LIMIT 0, 10 |
| 7366 | szxnmysql | localhost | szxndiscuz | Query | 1 | Sending data | SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,
m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6,
m.extcredits7, m.extcredits8, m.email, m.gender, m.showemail, m.invisible, mf.nickname, mf.site,
mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.fromcity, mf.fromtown, mf.nowcity, mf.nowtown, mf.medals,
mf.sightml AS signature, mf.customstatus, mf.spacename
FROM cdb_posts p
LEFT JOIN cdb_members m ON m.uid=p.authorid
LEFT JOIN cdb_memberfields mf ON mf.uid=m.uid
WHERE p.tid='16499' AND p.invisible='0' ORDER BY dateline LIMIT 0, 10 |
+------+-----------+-----------+------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
4 rows in set (0.54 sec) |
|