| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 84,682 | 905.3 | 79.67 |
| show tables | 5,722 | 61.2 | 5.38 |
| show fields | 4,486 | 48 | 4.22 |
| change db | 4,459 | 47.7 | 4.19 |
| set option | 3,213 | 34.3 | 3.02 |
| show keys | 1,442 | 15.4 | 1.36 |
| show variables | 888 | 9.5 | 0.84 |
| show grants | 312 | 3.3 | 0.29 |
| show binlogs | 209 | 2.2 | 0.20 |
| show create table | 153 | 1.6 | 0.14 |
| replace | 134 | 1.4 | 0.13 |
| stmt prepare | 132 | 1.4 | 0.12 |
| show storage engines | 94 | 1 | 0.09 |
| stmt close | 72 | 0.8 | 0.07 |
| stmt execute | 72 | 0.8 | 0.07 |
| show slave status | 62 | 0.7 | 0.06 |
| show master status | 56 | 0.6 | 0.05 |
| show warnings | 47 | 0.5 | 0.04 |
| show table status | 34 | 0.4 | 0.03 |
| show status | 23 | 0.2 | 0.02 |
| show processlist | 3 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |