| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 447 k | 2,189.9 | 45.95 |
| stmt execute | 106 k | 518.3 | 10.88 |
| stmt prepare | 103 k | 504.6 | 10.59 |
| stmt close | 103 k | 504.6 | 10.59 |
| set option | 82,411 | 404.1 | 8.48 |
| show tables | 51,243 | 251.2 | 5.27 |
| show fields | 19,524 | 95.7 | 2.01 |
| change db | 17,352 | 85.1 | 1.79 |
| update | 13,473 | 66.1 | 1.39 |
| insert | 6,677 | 32.7 | 0.69 |
| show keys | 6,141 | 30.1 | 0.63 |
| alter table | 4,646 | 22.8 | 0.48 |
| show variables | 2,774 | 13.6 | 0.29 |
| show grants | 1,917 | 9.4 | 0.20 |
| replace | 1,884 | 9.2 | 0.19 |
| show create table | 1,311 | 6.4 | 0.13 |
| begin | 771 | 3.8 | 0.08 |
| show binlogs | 732 | 3.6 | 0.08 |
| commit | 670 | 3.3 | 0.07 |
| delete | 668 | 3.3 | 0.07 |
| show storage engines | 481 | 2.4 | 0.05 |
| show warnings | 408 | 2 | 0.04 |
| create table | 171 | 0.8 | 0.02 |
| show slave status | 145 | 0.7 | 0.01 |
| show master status | 137 | 0.7 | 0.01 |
| show table status | 106 | 0.5 | 0.01 |
| rollback | 90 | 0.4 | 0.01 |
| show status | 41 | 0.2 | <0.01 |
| show processlist | 5 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |