控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 10,252 k | 90.5 k | 79.18 |
| show fields | 661 k | 5,834 | 5.11 |
| show tables | 555 k | 4,900.1 | 4.29 |
| change db | 443 k | 3,909.8 | 3.42 |
| set option | 333 k | 2,938.2 | 2.57 |
| show variables | 218 k | 1,926.7 | 1.69 |
| show keys | 117 k | 1,032.2 | 0.90 |
| show grants | 110 k | 966.4 | 0.85 |
| show create table | 109 k | 963.5 | 0.84 |
| show warnings | 109 k | 962.1 | 0.84 |
| replace | 39,640 | 349.8 | 0.31 |
| show binlogs | 307 | 2.7 | <0.01 |
| show storage engines | 255 | 2.3 | <0.01 |
| update | 225 | 2 | <0.01 |
| stmt prepare | 210 | 1.9 | <0.01 |
| stmt close | 115 | 1 | <0.01 |
| stmt execute | 115 | 1 | <0.01 |
| show master status | 30 | 0.3 | <0.01 |
| show slave status | 30 | 0.3 | <0.01 |
| show status | 15 | 0.1 | <0.01 |
| show table status | 4 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |