控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 12,210 k | 14.2 k | 33.61 |
| stmt execute | 6,771 k | 7,855.5 | 18.64 |
| insert | 3,836 k | 4,449.7 | 10.56 |
| stmt prepare | 3,627 k | 4,207.5 | 9.98 |
| stmt close | 3,623 k | 4,203.6 | 9.97 |
| show fields | 2,215 k | 2,569.6 | 6.10 |
| update | 1,911 k | 2,217 | 5.26 |
| show tables | 704 k | 816.9 | 1.94 |
| change db | 475 k | 551.1 | 1.31 |
| set option | 365 k | 423.8 | 1.01 |
| show keys | 213 k | 247.1 | 0.59 |
| show grants | 96,776 | 112.3 | 0.27 |
| show variables | 82,546 | 95.8 | 0.23 |
| replace | 80,143 | 93 | 0.22 |
| show create table | 56,717 | 65.8 | 0.16 |
| show warnings | 26,593 | 30.9 | 0.07 |
| show storage engines | 14,363 | 16.7 | 0.04 |
| show binlogs | 8,197 | 9.5 | 0.02 |
| show table status | 4,518 | 5.2 | 0.01 |
| delete | 1,899 | 2.2 | 0.01 |
| show slave status | 1,727 | 2 | <0.01 |
| show master status | 1,699 | 2 | <0.01 |
| alter table | 182 | 0.2 | <0.01 |
| show status | 176 | 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 | 21 | <0.1 | <0.01 |
| insert select | 20 | <0.1 | <0.01 |
| show engine status | 17 | <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 |