| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 17,561 k | 1,212.2 k | 80.54 |
| show fields | 917 k | 63.3 k | 4.21 |
| show tables | 766 k | 52.9 k | 3.51 |
| change db | 612 k | 42.2 k | 2.81 |
| show keys | 608 k | 42 k | 2.79 |
| set option | 460 k | 31.7 k | 2.11 |
| show variables | 305 k | 21.1 k | 1.40 |
| show grants | 153 k | 10.5 k | 0.70 |
| show create table | 153 k | 10.5 k | 0.70 |
| show warnings | 153 k | 10.5 k | 0.70 |
| replace | 114 k | 7,839.4 | 0.52 |
| stmt execute | 931 | 64.3 | <0.01 |
| stmt prepare | 931 | 64.3 | <0.01 |
| stmt close | 930 | 64.2 | <0.01 |
| alter table | 173 | 11.9 | <0.01 |
| show binlogs | 55 | 3.8 | <0.01 |
| update | 45 | 3.1 | <0.01 |
| show slave status | 35 | 2.4 | <0.01 |
| show master status | 32 | 2.2 | <0.01 |
| show storage engines | 29 | 2 | <0.01 |
| insert | 19 | 1.3 | <0.01 |
| show table status | 17 | 1.2 | <0.01 |
| show status | 8 | 0.6 | <0.01 |
| create table | 5 | 0.3 | <0.01 |
| begin | 3 | 0.2 | <0.01 |
| commit | 3 | 0.2 | <0.01 |
| delete | 1 | 0.1 | <0.01 |
| show processlist | 1 | 0.1 | <0.01 |