控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 68,617 k | 1,219.3 k | 80.08 |
| show fields | 3,592 k | 63.8 k | 4.19 |
| show tables | 3,005 k | 53.4 k | 3.51 |
| show keys | 2,785 k | 49.5 k | 3.25 |
| change db | 2,396 k | 42.6 k | 2.80 |
| set option | 1,823 k | 32.4 k | 2.13 |
| show variables | 1,197 k | 21.3 k | 1.40 |
| show grants | 598 k | 10.6 k | 0.70 |
| show create table | 598 k | 10.6 k | 0.70 |
| show warnings | 598 k | 10.6 k | 0.70 |
| replace | 373 k | 6,628.6 | 0.44 |
| stmt execute | 30,562 | 543.1 | 0.04 |
| stmt prepare | 29,738 | 528.4 | 0.03 |
| stmt close | 29,715 | 528 | 0.03 |
| update | 4,521 | 80.3 | 0.01 |
| insert | 1,998 | 35.5 | <0.01 |
| alter table | 1,174 | 20.9 | <0.01 |
| begin | 280 | 5 | <0.01 |
| commit | 240 | 4.3 | <0.01 |
| delete | 176 | 3.1 | <0.01 |
| create table | 104 | 1.8 | <0.01 |
| show binlogs | 89 | 1.6 | <0.01 |
| show storage engines | 39 | 0.7 | <0.01 |
| show slave status | 29 | 0.5 | <0.01 |
| rollback | 28 | 0.5 | <0.01 |
| show master status | 27 | 0.5 | <0.01 |
| show table status | 16 | 0.3 | <0.01 |
| show status | 9 | 0.2 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |