| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 70,875 | 398.7 k | 19.93 |
| stmt close | 56,694 | 318.9 k | 15.95 |
| stmt prepare | 56,694 | 318.9 k | 15.95 |
| stmt execute | 56,683 | 318.8 k | 15.94 |
| begin | 54,767 | 308.1 k | 15.40 |
| commit | 54,767 | 308.1 k | 15.40 |
| show tables | 1,196 | 6,727.5 | 0.34 |
| show fields | 890 | 5,006.3 | 0.25 |
| change db | 729 | 4,100.6 | 0.21 |
| set option | 558 | 3,138.8 | 0.16 |
| insert | 463 | 2,604.4 | 0.13 |
| update | 242 | 1,361.3 | 0.07 |
| create table | 221 | 1,243.1 | 0.06 |
| show keys | 211 | 1,186.9 | 0.06 |
| replace | 170 | 956.3 | 0.05 |
| show variables | 115 | 646.9 | 0.03 |
| show grants | 102 | 573.8 | 0.03 |
| show create table | 64 | 360 | 0.02 |
| show warnings | 26 | 146.3 | 0.01 |
| show storage engines | 13 | 73.1 | <0.01 |
| show table status | 13 | 73.1 | <0.01 |
| delete | 11 | 61.9 | <0.01 |
| insert select | 11 | 61.9 | <0.01 |
| show binlogs | 8 | 45 | <0.01 |
| show status | 7 | 39.4 | <0.01 |
| show master status | 6 | 33.8 | <0.01 |
| show slave status | 6 | 33.8 | <0.01 |
| show processlist | 1 | 5.6 | <0.01 |