| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,068 k | 72.7 k | 76.73 |
| show tables | 142 k | 4,981.7 | 5.26 |
| show fields | 138 k | 4,843.9 | 5.11 |
| change db | 98,973 | 3,480 | 3.67 |
| show keys | 69,204 | 2,433.3 | 2.57 |
| set option | 57,580 | 2,024.6 | 2.14 |
| show variables | 27,196 | 956.2 | 1.01 |
| replace | 25,327 | 890.5 | 0.94 |
| show create table | 17,488 | 614.9 | 0.65 |
| show warnings | 11,912 | 418.8 | 0.44 |
| stmt execute | 11,344 | 398.9 | 0.42 |
| stmt close | 11,060 | 388.9 | 0.41 |
| stmt prepare | 11,060 | 388.9 | 0.41 |
| show storage engines | 2,730 | 96 | 0.10 |
| update | 1,184 | 41.6 | 0.04 |
| insert | 623 | 21.9 | 0.02 |
| show grants | 561 | 19.7 | 0.02 |
| alter table | 552 | 19.4 | 0.02 |
| show binlogs | 252 | 8.9 | 0.01 |
| show table status | 242 | 8.5 | 0.01 |
| show slave status | 213 | 7.5 | 0.01 |
| show master status | 196 | 6.9 | 0.01 |
| begin | 75 | 2.6 | <0.01 |
| commit | 65 | 2.3 | <0.01 |
| delete | 51 | 1.8 | <0.01 |
| show status | 23 | 0.8 | <0.01 |
| create table | 21 | 0.7 | <0.01 |
| rollback | 10 | 0.4 | <0.01 |
| show engine status | 4 | 0.1 | <0.01 |
| flush | 2 | 0.1 | <0.01 |
| show processlist | 2 | 0.1 | <0.01 |