??????????????????????????MySQL????ù????????????????????????????????????????????????????ж??????????????????????MySQL?? show processlist???????????????
?????????????show processlist????????????????????????????????????MySQL?????????????????????mysql?У????show processlist??????????????
mysql> show processlist;
+--------+-------------+--------------------+-------+---------+-------+----------------------------------+----------------------------------------------------------------------------------+
| Id     | User        | Host               | db    | Command | Time  | State                            | Info                                                                             |
+--------+-------------+--------------------+-------+---------+-------+----------------------------------+----------------------------------------------------------------------------------+
|      1 | system user |                    | NULL  | Connect | 342266| Waiting for master to send event | NULL                                                                             |
|      2 | system user |                    | hdpic | Connect |   872 | Locked                           | UPDATE a SET STATE=0 WHERE ID=83752                                              |
| 123890 | hdpic_read  | 192.168.1.79:54910 | hdpic | Query   |  1512 | Sending data                     | select z.ID??z.TITLE??z.CREATOR_USER_NICK??z.CREATOR_USER_IDEN??z.LASTEDITOR_TI      |
| 124906 | hdpic_read  | 192.168.1.39:18844 | hdpic | Query   |   845 | Locked                           | select * from a where ((ID = 78789) AND (STATE != 0))                            |
| 124912 | hdpic_read  | 192.168.1.39:18862 | hdpic | Query   |   845 | Locked                           | select * from a where ((ID = 16031) AND (STATE != 0))                            |
| 124914 | hdpic_read  | 192.168.1.39:18865 | hdpic | Query   |   837 | Locked                           | select * from a where ((ID = 39109) AND (STATE != 0))                            |
| 124917 | hdpic_read  | 192.168.1.39:18875 | hdpic | Query   |   833 | Locked                           | select * from a where ((ID = 16031) AND (STATE != 0))                            |
................
................
................
????????Locked???????????????????????????????????
??????????????Locked????????д??????????????????????????????????????????????????д???????????????????·?????????????????????UPDATE????????????SELECT???????????????????￡???????????????????????????????????????????????????????????Locked??????????DBA???????????????????????????λ????????????????
??????show processlist???????????????UPDATE????????????????a??????????MyISAM???ID??????????????????????????????????????????????????????????????????????帺?????iostat?п?I/Owait??????????д???????????????????????????
???????????????show processlist????????????????id 123890?????????????????????UPDATE???????е?????show full processlist??????????????ò??????????a????????????????????????????????д????????????д????????????????????У??????????????????
??????????Щ????????????????????????????????????????????????????е???????????????????