控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 419 k | 80 k | 77.03 |
| change db | 29,286 | 5,592.5 | 5.39 |
| show tables | 29,063 | 5,549.9 | 5.34 |
| set option | 23,229 | 4,435.8 | 4.27 |
| show fields | 22,879 | 4,369 | 4.21 |
| show keys | 8,197 | 1,565.3 | 1.51 |
| show variables | 3,764 | 718.8 | 0.69 |
| replace | 2,625 | 501.3 | 0.48 |
| show create table | 1,598 | 305.2 | 0.29 |
| update | 835 | 159.5 | 0.15 |
| show grants | 650 | 124.1 | 0.12 |
| show warnings | 578 | 110.4 | 0.11 |
| show storage engines | 515 | 98.3 | 0.09 |
| show binlogs | 310 | 59.2 | 0.06 |
| insert | 285 | 54.4 | 0.05 |
| show slave status | 160 | 30.6 | 0.03 |
| show master status | 150 | 28.6 | 0.03 |
| stmt close | 122 | 23.3 | 0.02 |
| stmt execute | 122 | 23.3 | 0.02 |
| stmt prepare | 122 | 23.3 | 0.02 |
| show table status | 121 | 23.1 | 0.02 |
| create table | 77 | 14.7 | 0.01 |
| show status | 60 | 11.5 | 0.01 |
| delete | 39 | 7.4 | 0.01 |
| alter table | 33 | 6.3 | 0.01 |
| truncate | 22 | 4.2 | <0.01 |
| drop table | 9 | 1.7 | <0.01 |
| update multi | 9 | 1.7 | <0.01 |
| show processlist | 8 | 1.5 | <0.01 |
| show engine status | 4 | 0.8 | <0.01 |
| create db | 2 | 0.4 | <0.01 |
| drop db | 1 | 0.2 | <0.01 |
| flush | 1 | 0.2 | <0.01 |
| optimize | 1 | 0.2 | <0.01 |
| repair | 1 | 0.2 | <0.01 |