控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 23,692 k | 4,618.3 | 77.72 |
| show tables | 1,643 k | 320.2 | 5.39 |
| change db | 1,302 k | 253.7 | 4.27 |
| show fields | 1,154 k | 224.9 | 3.78 |
| show variables | 1,103 k | 215 | 3.62 |
| set option | 975 k | 190 | 3.20 |
| show warnings | 297 k | 57.9 | 0.97 |
| show keys | 145 k | 28.3 | 0.48 |
| show grants | 70,009 | 13.6 | 0.23 |
| show create table | 56,128 | 10.9 | 0.18 |
| replace | 27,216 | 5.3 | 0.09 |
| show binlogs | 7,487 | 1.5 | 0.02 |
| show storage engines | 3,050 | 0.6 | 0.01 |
| stmt prepare | 2,230 | 0.4 | 0.01 |
| stmt close | 1,330 | 0.3 | <0.01 |
| stmt execute | 1,330 | 0.3 | <0.01 |
| show slave status | 1,212 | 0.2 | <0.01 |
| show master status | 1,158 | 0.2 | <0.01 |
| show table status | 624 | 0.1 | <0.01 |
| update | 368 | 0.1 | <0.01 |
| show status | 252 | <0.1 | <0.01 |
| flush | 38 | <0.1 | <0.01 |
| show processlist | 29 | <0.1 | <0.01 |
| insert | 25 | <0.1 | <0.01 |
| alter table | 24 | <0.1 | <0.01 |
| create db | 24 | <0.1 | <0.01 |
| create table | 24 | <0.1 | <0.01 |
| delete | 24 | <0.1 | <0.01 |
| drop db | 24 | <0.1 | <0.01 |
| reset | 18 | <0.1 | <0.01 |
| show engine status | 16 | <0.1 | <0.01 |
| show databases | 14 | <0.1 | <0.01 |
| grant | 9 | <0.1 | <0.01 |
| truncate | 9 | <0.1 | <0.01 |