控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 12,285 k | 14.2 k | 33.73 |
| stmt execute | 6,771 k | 7,802.8 | 18.59 |
| insert | 3,836 k | 4,419.8 | 10.53 |
| stmt prepare | 3,627 k | 4,179.4 | 9.96 |
| stmt close | 3,624 k | 4,175.6 | 9.95 |
| show fields | 2,219 k | 2,557.2 | 6.09 |
| update | 1,911 k | 2,202.1 | 5.25 |
| show tables | 709 k | 817.4 | 1.95 |
| change db | 478 k | 551.2 | 1.31 |
| set option | 368 k | 423.8 | 1.01 |
| show keys | 215 k | 247.9 | 0.59 |
| show grants | 97,575 | 112.4 | 0.27 |
| show variables | 83,175 | 95.8 | 0.23 |
| replace | 80,825 | 93.1 | 0.22 |
| show create table | 57,174 | 65.9 | 0.16 |
| show warnings | 26,814 | 30.9 | 0.07 |
| show storage engines | 14,421 | 16.6 | 0.04 |
| show binlogs | 8,251 | 9.5 | 0.02 |
| show table status | 4,540 | 5.2 | 0.01 |
| delete | 1,899 | 2.2 | 0.01 |
| show slave status | 1,734 | 2 | <0.01 |
| show master status | 1,706 | 2 | <0.01 |
| show status | 183 | 0.2 | <0.01 |
| alter table | 182 | 0.2 | <0.01 |
| truncate | 156 | 0.2 | <0.01 |
| create table | 87 | 0.1 | <0.01 |
| commit | 54 | 0.1 | <0.01 |
| begin | 53 | 0.1 | <0.01 |
| flush | 23 | <0.1 | <0.01 |
| show processlist | 22 | <0.1 | <0.01 |
| insert select | 20 | <0.1 | <0.01 |
| show engine status | 18 | <0.1 | <0.01 |
| show function status | 13 | <0.1 | <0.01 |
| show procedure status | 13 | <0.1 | <0.01 |
| drop table | 12 | <0.1 | <0.01 |
| grant | 9 | <0.1 | <0.01 |
| create db | 7 | <0.1 | <0.01 |
| alter user | 5 | <0.1 | <0.01 |
| create user | 4 | <0.1 | <0.01 |
| show databases | 3 | <0.1 | <0.01 |
| drop db | 3 | <0.1 | <0.01 |
| rollback | 2 | <0.1 | <0.01 |
| load | 2 | <0.1 | <0.01 |
| drop procedure | 2 | <0.1 | <0.01 |
| delete multi | 2 | <0.1 | <0.01 |
| create procedure | 1 | <0.1 | <0.01 |
| empty query | 1 | <0.1 | <0.01 |
| call procedure | 1 | <0.1 | <0.01 |
| alter db | 1 | <0.1 | <0.01 |