控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 325 M | 1,232 k | 80.21 |
| show fields | 17,371 k | 65.9 k | 4.29 |
| show tables | 13,906 k | 52.8 k | 3.43 |
| show keys | 13,464 k | 51.1 k | 3.33 |
| change db | 11,082 k | 42 k | 2.74 |
| set option | 8,192 k | 31.1 k | 2.02 |
| show variables | 5,533 k | 21 k | 1.37 |
| show grants | 2,767 k | 10.5 k | 0.68 |
| show create table | 2,764 k | 10.5 k | 0.68 |
| show warnings | 2,763 k | 10.5 k | 0.68 |
| replace | 1,690 k | 6,409.4 | 0.42 |
| stmt execute | 180 k | 683 | 0.04 |
| stmt prepare | 176 k | 666.4 | 0.04 |
| stmt close | 176 k | 666.3 | 0.04 |
| update | 22,008 | 83.5 | 0.01 |
| insert | 11,122 | 42.2 | <0.01 |
| alter table | 4,898 | 18.6 | <0.01 |
| show binlogs | 2,396 | 9.1 | <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.5 | <0.01 |
| show storage engines | 371 | 1.4 | <0.01 |
| rollback | 158 | 0.6 | <0.01 |
| show slave status | 101 | 0.4 | <0.01 |
| show master status | 95 | 0.4 | <0.01 |
| show table status | 72 | 0.3 | <0.01 |
| show status | 23 | 0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |