| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,130 k | 72 k | 76.63 |
| show tables | 146 k | 4,944.2 | 5.26 |
| show fields | 141 k | 4,771.3 | 5.08 |
| change db | 102 k | 3,452.8 | 3.67 |
| show keys | 70,251 | 2,375.1 | 2.53 |
| set option | 60,309 | 2,039 | 2.17 |
| show variables | 27,833 | 941 | 1.00 |
| replace | 25,458 | 860.7 | 0.92 |
| show create table | 17,613 | 595.5 | 0.63 |
| stmt execute | 13,246 | 447.8 | 0.48 |
| stmt close | 12,872 | 435.2 | 0.46 |
| stmt prepare | 12,872 | 435.2 | 0.46 |
| show warnings | 11,938 | 403.6 | 0.43 |
| show storage engines | 2,769 | 93.6 | 0.10 |
| update | 1,473 | 49.8 | 0.05 |
| insert | 772 | 26.1 | 0.03 |
| show grants | 726 | 24.5 | 0.03 |
| alter table | 621 | 21 | 0.02 |
| show binlogs | 367 | 12.4 | 0.01 |
| show table status | 255 | 8.6 | 0.01 |
| show slave status | 239 | 8.1 | 0.01 |
| show master status | 220 | 7.4 | 0.01 |
| begin | 86 | 2.9 | <0.01 |
| commit | 74 | 2.5 | <0.01 |
| delete | 56 | 1.9 | <0.01 |
| show status | 42 | 1.4 | <0.01 |
| create table | 32 | 1.1 | <0.01 |
| rollback | 12 | 0.4 | <0.01 |
| show engine status | 5 | 0.2 | <0.01 |
| show processlist | 5 | 0.2 | <0.01 |
| flush | 3 | 0.1 | <0.01 |