控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 71,050 k | 1,217.5 k | 80.07 |
| show fields | 3,721 k | 63.8 k | 4.19 |
| show tables | 3,116 k | 53.4 k | 3.51 |
| show keys | 2,882 k | 49.4 k | 3.25 |
| change db | 2,483 k | 42.6 k | 2.80 |
| set option | 1,890 k | 32.4 k | 2.13 |
| show variables | 1,239 k | 21.2 k | 1.40 |
| show create table | 619 k | 10.6 k | 0.70 |
| show grants | 619 k | 10.6 k | 0.70 |
| show warnings | 619 k | 10.6 k | 0.70 |
| replace | 387 k | 6,630.7 | 0.44 |
| stmt execute | 33,948 | 581.8 | 0.04 |
| stmt prepare | 33,076 | 566.8 | 0.04 |
| stmt close | 33,048 | 566.3 | 0.04 |
| update | 4,859 | 83.3 | 0.01 |
| insert | 2,199 | 37.7 | <0.01 |
| alter table | 1,349 | 23.1 | <0.01 |
| begin | 318 | 5.4 | <0.01 |
| commit | 267 | 4.6 | <0.01 |
| show storage engines | 240 | 4.1 | <0.01 |
| delete | 188 | 3.2 | <0.01 |
| show binlogs | 185 | 3.2 | <0.01 |
| create table | 116 | 2 | <0.01 |
| show slave status | 44 | 0.8 | <0.01 |
| show table status | 44 | 0.8 | <0.01 |
| show master status | 40 | 0.7 | <0.01 |
| rollback | 33 | 0.6 | <0.01 |
| show status | 15 | 0.3 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |