????mysqladmin?????????debug????????????????MySQL????????????????????????????????λ?????????????????????????????????????μ??MySQL???????????????mysqladmin???????￡?
????[root@phpmysql02 data]# mysqladmin -ujss -p -S /data/3306/mysql.sock debug
????Enter password:
????debug????????????mysql??????????????????????????????У??????????????????error log???У?
[root@phpmysql02 data]# tail -10 phpmysql02.err
Thread database.table_name          Locked/Waiting        Lock_type
2       hdpic.t_wiki_zutu           Waiting - write       Highest priority write lock
123890  hdpic.t_wiki_zutu_category  Locked - read         Low priority read lock
123890  hdpic.t_wiki_zutu_photo     Locked - read         Low priority read lock
123890  hdpic.t_wiki_zutu           Locked - read         Low priority read lock
124906  hdpic.t_wiki_zutu           Waiting - read        Low priority read lock
??????????????????????123890???е??????????2??д???124906??????????????????????????????????????????????????????????????????????????123890???????????????
????mysql> kill 123890;
????Query OK?? 0 rows affected (0.00 sec)
??????????show processlist????
mysql> show processlist;
+--------+-------------+--------------------+-------+---------+--------+----------------------------------+------------------+
| Id     | User        | Host               | db    | Command | Time   | State                            | Info             |
+--------+-------------+--------------------+-------+---------+--------+----------------------------------+------------------+
|      1 | system user |                    | NULL  | Connect | 342390 | Waiting for master to send event | NULL             |
| 124906 | hdpic_read  | 192.168.1.39:18844 | hdpic | Sleep   |      1 |                                  | NULL             |
| 124912 | hdpic_read  | 192.168.1.39:18862 | hdpic | Sleep   |      2 |                                  | NULL             |
| 124914 | hdpic_read  | 192.168.1.39:18865 | hdpic | Sleep   |      1 |                                  | NULL             |
| 124917 | hdpic_read  | 192.168.1.39:18875 | hdpic | Sleep   |      1 |                                  | NULL             |
| 124919 | hdpic_read  | 192.168.1.39:18877 | hdpic | Sleep   |      2 |                                  | NULL             |
................
................
................
??????????Locked??????????????????????????????????????????????????????????