控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 975 k | 608.7 | 80.22 |
| show fields | 47,553 | 29.7 | 3.91 |
| show tables | 45,194 | 28.2 | 3.72 |
| change db | 36,369 | 22.7 | 2.99 |
| set option | 34,818 | 21.7 | 2.86 |
| show keys | 19,450 | 12.1 | 1.60 |
| show variables | 10,546 | 6.6 | 0.87 |
| update | 9,818 | 6.1 | 0.81 |
| show grants | 7,468 | 4.7 | 0.61 |
| replace | 6,426 | 4 | 0.53 |
| show create table | 6,131 | 3.8 | 0.50 |
| insert | 5,700 | 3.6 | 0.47 |
| show warnings | 4,686 | 2.9 | 0.39 |
| delete | 4,000 | 2.5 | 0.33 |
| show storage engines | 573 | 0.4 | 0.05 |
| show binlogs | 482 | 0.3 | 0.04 |
| delete multi | 201 | 0.1 | 0.02 |
| stmt prepare | 155 | 0.1 | 0.01 |
| insert select | 149 | 0.1 | 0.01 |
| show table status | 133 | 0.1 | 0.01 |
| stmt close | 100 | 0.1 | 0.01 |
| stmt execute | 100 | 0.1 | 0.01 |
| show slave status | 90 | 0.1 | 0.01 |
| show master status | 86 | 0.1 | 0.01 |
| alter table | 52 | <0.1 | <0.01 |
| create table | 28 | <0.1 | <0.01 |
| show status | 25 | <0.1 | <0.01 |
| show engine status | 11 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| begin | 1 | <0.1 | <0.01 |
| commit | 1 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| drop table | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |