控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 7,956 k | 89.7 k | 79.23 |
| show fields | 509 k | 5,743.3 | 5.07 |
| show tables | 427 k | 4,820.8 | 4.26 |
| change db | 341 k | 3,848.5 | 3.40 |
| set option | 256 k | 2,890.3 | 2.55 |
| show variables | 168 k | 1,897.3 | 1.68 |
| show keys | 90,630 | 1,022.2 | 0.90 |
| show grants | 84,420 | 952.1 | 0.84 |
| show create table | 84,139 | 949 | 0.84 |
| show warnings | 83,991 | 947.3 | 0.84 |
| replace | 39,001 | 439.9 | 0.39 |
| show storage engines | 231 | 2.6 | <0.01 |
| show binlogs | 206 | 2.3 | <0.01 |
| stmt prepare | 199 | 2.2 | <0.01 |
| update | 147 | 1.7 | <0.01 |
| stmt close | 109 | 1.2 | <0.01 |
| stmt execute | 109 | 1.2 | <0.01 |
| show master status | 22 | 0.2 | <0.01 |
| show slave status | 22 | 0.2 | <0.01 |
| show status | 9 | 0.1 | <0.01 |
| show table status | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |