| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,274 k | 71.1 k | 76.03 |
| show tables | 159 k | 4,971.6 | 5.32 |
| show fields | 150 k | 4,693.1 | 5.02 |
| change db | 109 k | 3,419 | 3.66 |
| show keys | 74,322 | 2,322.2 | 2.48 |
| set option | 69,000 | 2,155.9 | 2.31 |
| show variables | 28,994 | 905.9 | 0.97 |
| replace | 26,885 | 840 | 0.90 |
| stmt execute | 19,751 | 617.1 | 0.66 |
| stmt close | 19,270 | 602.1 | 0.64 |
| stmt prepare | 19,270 | 602.1 | 0.64 |
| show create table | 18,413 | 575.3 | 0.62 |
| show warnings | 12,251 | 382.8 | 0.41 |
| show storage engines | 2,994 | 93.5 | 0.10 |
| update | 2,132 | 66.6 | 0.07 |
| show grants | 1,276 | 39.9 | 0.04 |
| insert | 1,171 | 36.6 | 0.04 |
| alter table | 971 | 30.3 | 0.03 |
| show binlogs | 462 | 14.4 | 0.02 |
| show table status | 299 | 9.3 | 0.01 |
| show slave status | 249 | 7.8 | 0.01 |
| show master status | 230 | 7.2 | 0.01 |
| begin | 130 | 4.1 | <0.01 |
| commit | 107 | 3.3 | <0.01 |
| delete | 75 | 2.3 | <0.01 |
| show status | 49 | 1.5 | <0.01 |
| create table | 34 | 1.1 | <0.01 |
| rollback | 22 | 0.7 | <0.01 |
| show engine status | 7 | 0.2 | <0.01 |
| show processlist | 6 | 0.2 | <0.01 |
| flush | 4 | 0.1 | <0.01 |