| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 404 k | 1,997.6 | 44.12 |
| stmt execute | 106 k | 522.1 | 11.53 |
| stmt prepare | 103 k | 508.3 | 11.23 |
| stmt close | 103 k | 508.3 | 11.23 |
| set option | 81,365 | 401.8 | 8.87 |
| show tables | 47,924 | 236.7 | 5.23 |
| show fields | 16,443 | 81.2 | 1.79 |
| change db | 15,080 | 74.5 | 1.64 |
| update | 13,473 | 66.5 | 1.47 |
| insert | 6,677 | 33 | 0.73 |
| alter table | 4,646 | 22.9 | 0.51 |
| show keys | 4,313 | 21.3 | 0.47 |
| show variables | 2,400 | 11.9 | 0.26 |
| show grants | 1,770 | 8.7 | 0.19 |
| replace | 1,461 | 7.2 | 0.16 |
| show create table | 1,059 | 5.2 | 0.12 |
| begin | 771 | 3.8 | 0.08 |
| show binlogs | 712 | 3.5 | 0.08 |
| commit | 670 | 3.3 | 0.07 |
| delete | 668 | 3.3 | 0.07 |
| show storage engines | 405 | 2 | 0.04 |
| show warnings | 316 | 1.6 | 0.03 |
| create table | 171 | 0.8 | 0.02 |
| show slave status | 137 | 0.7 | 0.01 |
| show master status | 129 | 0.6 | 0.01 |
| show table status | 100 | 0.5 | 0.01 |
| rollback | 90 | 0.4 | 0.01 |
| show status | 34 | 0.2 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |