控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 244 M | 325.5 k | 79.89 |
| show tables | 15,145 k | 20.2 k | 4.96 |
| show fields | 12,801 k | 17.1 k | 4.19 |
| change db | 10,326 k | 13.8 k | 3.38 |
| set option | 9,088 k | 12.1 k | 2.98 |
| show keys | 5,633 k | 7,513.1 | 1.84 |
| show variables | 2,472 k | 3,296.5 | 0.81 |
| show grants | 1,246 k | 1,661.6 | 0.41 |
| show create table | 1,237 k | 1,650.3 | 0.41 |
| show warnings | 1,235 k | 1,646.8 | 0.40 |
| show binlogs | 1,175 k | 1,567.3 | 0.38 |
| replace | 954 k | 1,272.8 | 0.31 |
| update | 120 k | 160.5 | 0.04 |
| show storage engines | 2,256 | 3 | <0.01 |
| stmt prepare | 1,380 | 1.8 | <0.01 |
| stmt close | 772 | 1 | <0.01 |
| stmt execute | 772 | 1 | <0.01 |
| insert | 568 | 0.8 | <0.01 |
| delete | 410 | 0.5 | <0.01 |
| show slave status | 122 | 0.2 | <0.01 |
| show master status | 118 | 0.2 | <0.01 |
| show table status | 112 | 0.1 | <0.01 |
| show status | 26 | <0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |