| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 72,551 k | 1,216.4 k | 80.07 |
| show fields | 3,800 k | 63.7 k | 4.19 |
| show tables | 3,183 k | 53.4 k | 3.51 |
| show keys | 2,943 k | 49.3 k | 3.25 |
| change db | 2,536 k | 42.5 k | 2.80 |
| set option | 1,931 k | 32.4 k | 2.13 |
| show variables | 1,264 k | 21.2 k | 1.40 |
| show create table | 632 k | 10.6 k | 0.70 |
| show grants | 632 k | 10.6 k | 0.70 |
| show warnings | 632 k | 10.6 k | 0.70 |
| replace | 395 k | 6,629.8 | 0.44 |
| stmt execute | 35,134 | 589.1 | 0.04 |
| stmt prepare | 34,188 | 573.2 | 0.04 |
| stmt close | 34,160 | 572.7 | 0.04 |
| update | 5,079 | 85.2 | 0.01 |
| insert | 2,297 | 38.5 | <0.01 |
| alter table | 1,392 | 23.3 | <0.01 |
| begin | 330 | 5.5 | <0.01 |
| commit | 279 | 4.7 | <0.01 |
| show storage engines | 271 | 4.5 | <0.01 |
| show binlogs | 209 | 3.5 | <0.01 |
| delete | 195 | 3.3 | <0.01 |
| create table | 124 | 2.1 | <0.01 |
| show table status | 69 | 1.2 | <0.01 |
| show slave status | 50 | 0.8 | <0.01 |
| show master status | 46 | 0.8 | <0.01 |
| rollback | 33 | 0.6 | <0.01 |
| show status | 24 | 0.4 | <0.01 |
| show processlist | 3 | 0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |