控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 326 M | 1,232.4 k | 80.22 |
| show fields | 17,467 k | 65.9 k | 4.29 |
| show tables | 13,981 k | 52.8 k | 3.44 |
| show keys | 13,534 k | 51.1 k | 3.33 |
| change db | 11,142 k | 42.1 k | 2.74 |
| set option | 8,222 k | 31 k | 2.02 |
| show variables | 5,561 k | 21 k | 1.37 |
| show grants | 2,781 k | 10.5 k | 0.68 |
| show create table | 2,778 k | 10.5 k | 0.68 |
| show warnings | 2,777 k | 10.5 k | 0.68 |
| replace | 1,699 k | 6,415.3 | 0.42 |
| stmt execute | 180 k | 680.5 | 0.04 |
| stmt prepare | 176 k | 663.9 | 0.04 |
| stmt close | 176 k | 663.9 | 0.04 |
| update | 22,010 | 83.1 | 0.01 |
| insert | 11,122 | 42 | <0.01 |
| alter table | 4,898 | 18.5 | <0.01 |
| show binlogs | 2,501 | 9.4 | <0.01 |
| begin | 1,295 | 4.9 | <0.01 |
| commit | 1,111 | 4.2 | <0.01 |
| delete | 1,033 | 3.9 | <0.01 |
| show storage engines | 597 | 2.3 | <0.01 |
| create table | 407 | 1.5 | <0.01 |
| rollback | 158 | 0.6 | <0.01 |
| show slave status | 116 | 0.4 | <0.01 |
| show master status | 110 | 0.4 | <0.01 |
| show table status | 102 | 0.4 | <0.01 |
| show status | 40 | 0.2 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |