控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 325 M | 1,232 k | 80.21 |
| show fields | 17,376 k | 65.9 k | 4.29 |
| show tables | 13,910 k | 52.8 k | 3.43 |
| show keys | 13,468 k | 51.1 k | 3.33 |
| change db | 11,085 k | 42 k | 2.74 |
| set option | 8,194 k | 31.1 k | 2.02 |
| show variables | 5,534 k | 21 k | 1.37 |
| show grants | 2,768 k | 10.5 k | 0.68 |
| show create table | 2,765 k | 10.5 k | 0.68 |
| show warnings | 2,764 k | 10.5 k | 0.68 |
| replace | 1,690 k | 6,409.8 | 0.42 |
| stmt execute | 180 k | 682.8 | 0.04 |
| stmt prepare | 176 k | 666.2 | 0.04 |
| stmt close | 176 k | 666.2 | 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,411 | 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 | 391 | 1.5 | <0.01 |
| rollback | 158 | 0.6 | <0.01 |
| show slave status | 106 | 0.4 | <0.01 |
| show master status | 100 | 0.4 | <0.01 |
| show table status | 74 | 0.3 | <0.01 |
| show status | 30 | 0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |