| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,481 k | 1,620.5 | 78.21 |
| show tables | 99,362 | 108.7 | 5.25 |
| show fields | 87,220 | 95.5 | 4.61 |
| change db | 72,958 | 79.8 | 3.85 |
| set option | 54,759 | 59.9 | 2.89 |
| show keys | 41,611 | 45.5 | 2.20 |
| show variables | 20,075 | 22 | 1.06 |
| replace | 11,760 | 12.9 | 0.62 |
| show create table | 9,097 | 10 | 0.48 |
| show warnings | 6,644 | 7.3 | 0.35 |
| show grants | 3,286 | 3.6 | 0.17 |
| show binlogs | 2,863 | 3.1 | 0.15 |
| show storage engines | 1,129 | 1.2 | 0.06 |
| stmt close | 333 | 0.4 | 0.02 |
| stmt execute | 333 | 0.4 | 0.02 |
| stmt prepare | 333 | 0.4 | 0.02 |
| show slave status | 270 | 0.3 | 0.01 |
| show master status | 258 | 0.3 | 0.01 |
| show table status | 146 | 0.2 | 0.01 |
| show status | 30 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |