| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 323 M | 1,231.6 k | 80.21 |
| show fields | 17,278 k | 65.9 k | 4.29 |
| show tables | 13,832 k | 52.7 k | 3.43 |
| show keys | 13,396 k | 51.1 k | 3.33 |
| change db | 11,023 k | 42 k | 2.74 |
| set option | 8,163 k | 31.1 k | 2.03 |
| show variables | 5,505 k | 21 k | 1.37 |
| show grants | 2,753 k | 10.5 k | 0.68 |
| show create table | 2,750 k | 10.5 k | 0.68 |
| show warnings | 2,750 k | 10.5 k | 0.68 |
| replace | 1,680 k | 6,405.7 | 0.42 |
| stmt execute | 180 k | 686.1 | 0.04 |
| stmt prepare | 176 k | 669.4 | 0.04 |
| stmt close | 176 k | 669.4 | 0.04 |
| update | 22,008 | 83.9 | 0.01 |
| insert | 11,122 | 42.4 | <0.01 |
| alter table | 4,898 | 18.7 | <0.01 |
| show binlogs | 2,215 | 8.4 | <0.01 |
| begin | 1,295 | 4.9 | <0.01 |
| commit | 1,111 | 4.2 | <0.01 |
| delete | 1,033 | 3.9 | <0.01 |
| create table | 407 | 1.6 | <0.01 |
| show storage engines | 297 | 1.1 | <0.01 |
| rollback | 158 | 0.6 | <0.01 |
| show slave status | 76 | 0.3 | <0.01 |
| show master status | 71 | 0.3 | <0.01 |
| show table status | 43 | 0.2 | <0.01 |
| show status | 8 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |