kenny

gistfile1.txt

root@kenny [~]# mysqladmin proc
+----------+------------------+-----------+---------------------+---------+-------+------------------------------+------------------------------------------------------------------------------------------------------+-----------+---------------+-----------+
| Id       | User             | Host      | db                  | Command | Time  | State                        | Info                                                                                                 | Rows_sent | Rows_examined | Rows_read |
+----------+------------------+-----------+---------------------+---------+-------+------------------------------+------------------------------------------------------------------------------------------------------+-----------+---------------+-----------+
| 29655324 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 71216 | Sending data                 | select * from g4_write_qa where wr_is_comment = 0  order by wr_num, wr_reply   limit 1084400, 16     | 0         | 0             | 0         |
| 29655335 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 71204 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1102946'                                                    | 0         | 0             | 0         |
| 29655350 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 71205 | Waiting for table level lock | update g4_write_qa set wr_hit = wr_hit + 1 where wr_id = '1103960'                                   | 0         | 0             | 0         |
| 29655871 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 70857 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1104018'                                                    | 0         | 0             | 0         |
| 29655876 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 70857 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1075512'                                                    | 0         | 0             | 0         |
| 29655881 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 70857 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1098089'                                                    | 0         | 0             | 0         |
| 29656773 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 70497 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1104312'                                                    | 0         | 0             | 0         |
| 29656776 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 70497 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1099198'                                                    | 0         | 0             | 0         |
| 29657052 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 70317 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1101950'                                                    | 0         | 0             | 0         |
| 29657058 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 70317 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1103126'                                                    | 0         | 0             | 0         |
| 29657093 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 70313 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1022698'                                                    | 0         | 0             | 0         |
| 29658074 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 69954 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1100778'                                                    | 0         | 0             | 0         |
| 29658075 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 69954 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1098709'                                                    | 0         | 0             | 0         |
| 29658139 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 69922 | Waiting for table level lock | select * from g4_write_qa where wr_id = '23756'                                                      | 0         | 0             | 0         |
| 29658733 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 69579 | Waiting for table level lock | select MD5(CONCAT(wr_ip, wr_subject, wr_content)) as prev_md5 from g4_write_qa order by wr_id desc l | 0         | 0             | 0         |
| 29658773 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 69564 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1104165'                                                    | 0         | 0             | 0         |
| 29658774 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 69564 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1099172'                                                    | 0         | 0             | 0         |
| 29659734 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 69184 | Waiting for table level lock | select * from g4_write_qa where wr_is_comment = 0  order by wr_num, wr_reply   limit 0, 16           | 0         | 0             | 0         |
| 29659740 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 69226 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1103003'                                                    | 0         | 0             | 0         |
| 29660293 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 68898 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1098740'                                                    | 0         | 0             | 0         |
| 29660323 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 68897 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1076208'                                                    | 0         | 0             | 0         |
| 29660326 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 68897 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1104209'                                                    | 0         | 0             | 0         |
| 29660973 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 68534 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1103398'                                                    | 0         | 0             | 0         |
| 29660979 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 68534 | Waiting for table level lock | select * from g4_write_qa where wr_id = '1104002'                                                    | 0         | 0             | 0         |
| 29661006 | canaanor_canaanx | localhost | canaanor_canaan2    | Query   | 68518 | Waiting for table level lock | select * from g4_write_qa where wr_is_comment = 0  order by wr_num, wr_reply   limit 0, 16           | 0         | 0             | 0         |