| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 387 k | 28.2 k | 77.89 |
| show tables | 29,062 | 2,121.6 | 5.85 |
| show fields | 24,469 | 1,786.3 | 4.93 |
| change db | 20,416 | 1,490.4 | 4.11 |
| set option | 14,239 | 1,039.5 | 2.87 |
| show keys | 8,859 | 646.7 | 1.78 |
| replace | 3,604 | 263.1 | 0.73 |
| show variables | 3,361 | 245.4 | 0.68 |
| show create table | 2,279 | 166.4 | 0.46 |
| show grants | 1,294 | 94.5 | 0.26 |
| show warnings | 636 | 46.4 | 0.13 |
| show storage engines | 586 | 42.8 | 0.12 |
| show table status | 300 | 21.9 | 0.06 |
| show binlogs | 266 | 19.4 | 0.05 |
| stmt prepare | 143 | 10.4 | 0.03 |
| stmt close | 77 | 5.6 | 0.02 |
| stmt execute | 77 | 5.6 | 0.02 |
| show slave status | 54 | 3.9 | 0.01 |
| show master status | 51 | 3.7 | 0.01 |
| show status | 29 | 2.1 | 0.01 |
| show processlist | 4 | 0.3 | <0.01 |
| show engine status | 3 | 0.2 | <0.01 |
| flush | 1 | 0.1 | <0.01 |
| show databases | 1 | 0.1 | <0.01 |