控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,059 k | 644.1 | 80.09 |
| show fields | 52,657 | 32 | 3.98 |
| show tables | 49,620 | 30.2 | 3.75 |
| change db | 39,738 | 24.2 | 3.00 |
| set option | 37,473 | 22.8 | 2.83 |
| show keys | 21,978 | 13.4 | 1.66 |
| show variables | 11,861 | 7.2 | 0.90 |
| update | 10,039 | 6.1 | 0.76 |
| show grants | 8,291 | 5 | 0.63 |
| replace | 7,010 | 4.3 | 0.53 |
| show create table | 6,924 | 4.2 | 0.52 |
| insert | 5,788 | 3.5 | 0.44 |
| show warnings | 5,308 | 3.2 | 0.40 |
| delete | 4,090 | 2.5 | 0.31 |
| show storage engines | 595 | 0.4 | 0.04 |
| show binlogs | 561 | 0.3 | 0.04 |
| delete multi | 204 | 0.1 | 0.02 |
| stmt prepare | 199 | 0.1 | 0.02 |
| insert select | 153 | 0.1 | 0.01 |
| show table status | 149 | 0.1 | 0.01 |
| stmt close | 124 | 0.1 | 0.01 |
| stmt execute | 124 | 0.1 | 0.01 |
| show slave status | 114 | 0.1 | 0.01 |
| show master status | 107 | 0.1 | 0.01 |
| alter table | 52 | <0.1 | <0.01 |
| show status | 33 | <0.1 | <0.01 |
| create table | 28 | <0.1 | <0.01 |
| show engine status | 12 | <0.1 | <0.01 |
| show processlist | 3 | <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 |
| flush | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |