| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,047 k | 1,286.7 | 77.43 |
| show tables | 70,452 | 86.6 | 5.21 |
| show fields | 66,021 | 81.1 | 4.88 |
| change db | 49,124 | 60.4 | 3.63 |
| show keys | 39,697 | 48.8 | 2.93 |
| set option | 36,189 | 44.5 | 2.68 |
| show grants | 9,646 | 11.9 | 0.71 |
| show create table | 9,352 | 11.5 | 0.69 |
| show variables | 7,956 | 9.8 | 0.59 |
| replace | 7,331 | 9 | 0.54 |
| show binlogs | 2,654 | 3.3 | 0.20 |
| show warnings | 1,774 | 2.2 | 0.13 |
| show storage engines | 1,392 | 1.7 | 0.10 |
| stmt prepare | 1,295 | 1.6 | 0.10 |
| stmt close | 760 | 0.9 | 0.06 |
| stmt execute | 760 | 0.9 | 0.06 |
| show slave status | 348 | 0.4 | 0.03 |
| show master status | 336 | 0.4 | 0.02 |
| show table status | 157 | 0.2 | 0.01 |
| show status | 54 | 0.1 | <0.01 |
| update | 42 | 0.1 | <0.01 |
| show processlist | 7 | <0.1 | <0.01 |
| show engine status | 6 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |