控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 23,727 k | 4,620.4 | 77.72 |
| show tables | 1,645 k | 320.4 | 5.39 |
| change db | 1,304 k | 253.9 | 4.27 |
| show fields | 1,155 k | 225 | 3.78 |
| show variables | 1,105 k | 215.1 | 3.62 |
| set option | 976 k | 190.1 | 3.20 |
| show warnings | 297 k | 57.9 | 0.97 |
| show keys | 145 k | 28.3 | 0.48 |
| show grants | 70,098 | 13.7 | 0.23 |
| show create table | 56,174 | 10.9 | 0.18 |
| replace | 27,231 | 5.3 | 0.09 |
| show binlogs | 7,531 | 1.5 | 0.02 |
| show storage engines | 3,063 | 0.6 | 0.01 |
| stmt prepare | 2,253 | 0.4 | 0.01 |
| stmt close | 1,343 | 0.3 | <0.01 |
| stmt execute | 1,343 | 0.3 | <0.01 |
| show slave status | 1,222 | 0.2 | <0.01 |
| show master status | 1,168 | 0.2 | <0.01 |
| show table status | 631 | 0.1 | <0.01 |
| update | 368 | 0.1 | <0.01 |
| show status | 259 | 0.1 | <0.01 |
| flush | 38 | <0.1 | <0.01 |
| show processlist | 30 | <0.1 | <0.01 |
| insert | 25 | <0.1 | <0.01 |
| alter table | 24 | <0.1 | <0.01 |
| create db | 24 | <0.1 | <0.01 |
| create table | 24 | <0.1 | <0.01 |
| delete | 24 | <0.1 | <0.01 |
| drop db | 24 | <0.1 | <0.01 |
| reset | 18 | <0.1 | <0.01 |
| show engine status | 16 | <0.1 | <0.01 |
| show databases | 14 | <0.1 | <0.01 |
| grant | 9 | <0.1 | <0.01 |
| truncate | 9 | <0.1 | <0.01 |