| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 31,898 k | 28.8 k | 79.58 |
| show fields | 2,124 k | 1,917.5 | 5.30 |
| show tables | 1,687 k | 1,522.7 | 4.21 |
| change db | 1,292 k | 1,166.5 | 3.22 |
| set option | 1,006 k | 908.4 | 2.51 |
| show keys | 569 k | 513.3 | 1.42 |
| show variables | 557 k | 502.9 | 1.39 |
| show create table | 280 k | 252.3 | 0.70 |
| show grants | 277 k | 250.3 | 0.69 |
| show warnings | 277 k | 250.2 | 0.69 |
| replace | 91,157 | 82.3 | 0.23 |
| show binlogs | 11,560 | 10.4 | 0.03 |
| update | 7,889 | 7.1 | 0.02 |
| show storage engines | 1,540 | 1.4 | <0.01 |
| insert | 499 | 0.5 | <0.01 |
| stmt prepare | 371 | 0.3 | <0.01 |
| show slave status | 258 | 0.2 | <0.01 |
| show master status | 249 | 0.2 | <0.01 |
| stmt close | 241 | 0.2 | <0.01 |
| stmt execute | 241 | 0.2 | <0.01 |
| show table status | 171 | 0.2 | <0.01 |
| show status | 51 | <0.1 | <0.01 |
| show processlist | 6 | <0.1 | <0.01 |
| show engine status | 5 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |