控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 207 k | 41.7 k | 76.18 |
| change db | 18,130 | 3,640.2 | 6.66 |
| set option | 15,244 | 3,060.7 | 5.60 |
| show tables | 12,768 | 2,563.6 | 4.69 |
| show fields | 9,936 | 1,995 | 3.65 |
| show keys | 3,137 | 629.8 | 1.15 |
| show variables | 1,502 | 301.6 | 0.55 |
| update | 835 | 167.7 | 0.31 |
| replace | 781 | 156.8 | 0.29 |
| show create table | 613 | 123.1 | 0.23 |
| insert | 285 | 57.2 | 0.10 |
| show grants | 261 | 52.4 | 0.10 |
| show storage engines | 247 | 49.6 | 0.09 |
| show binlogs | 179 | 35.9 | 0.07 |
| show slave status | 133 | 26.7 | 0.05 |
| show master status | 124 | 24.9 | 0.05 |
| stmt close | 109 | 21.9 | 0.04 |
| stmt execute | 109 | 21.9 | 0.04 |
| stmt prepare | 109 | 21.9 | 0.04 |
| show table status | 80 | 16.1 | 0.03 |
| create table | 77 | 15.5 | 0.03 |
| show warnings | 42 | 8.4 | 0.02 |
| delete | 39 | 7.8 | 0.01 |
| show status | 36 | 7.2 | 0.01 |
| alter table | 33 | 6.6 | 0.01 |
| truncate | 22 | 4.4 | 0.01 |
| drop table | 9 | 1.8 | <0.01 |
| update multi | 9 | 1.8 | <0.01 |
| show processlist | 5 | 1 | <0.01 |
| create db | 2 | 0.4 | <0.01 |
| drop db | 1 | 0.2 | <0.01 |
| optimize | 1 | 0.2 | <0.01 |
| repair | 1 | 0.2 | <0.01 |
| show engine status | 1 | 0.2 | <0.01 |