控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 26,484 k | 4,636.8 | 77.69 |
| show tables | 1,847 k | 323.3 | 5.42 |
| change db | 1,464 k | 256.3 | 4.29 |
| show fields | 1,280 k | 224.1 | 3.75 |
| show variables | 1,255 k | 219.7 | 3.68 |
| set option | 1,096 k | 192 | 3.22 |
| show warnings | 335 k | 58.7 | 0.98 |
| show keys | 150 k | 26.3 | 0.44 |
| show grants | 72,833 | 12.8 | 0.21 |
| show create table | 57,604 | 10.1 | 0.17 |
| replace | 28,613 | 5 | 0.08 |
| show binlogs | 8,474 | 1.5 | 0.02 |
| show storage engines | 3,249 | 0.6 | 0.01 |
| stmt prepare | 2,365 | 0.4 | 0.01 |
| stmt close | 1,405 | 0.2 | <0.01 |
| stmt execute | 1,405 | 0.2 | <0.01 |
| show slave status | 1,393 | 0.2 | <0.01 |
| show master status | 1,331 | 0.2 | <0.01 |
| show table status | 674 | 0.1 | <0.01 |
| update | 368 | 0.1 | <0.01 |
| show status | 285 | <0.1 | <0.01 |
| flush | 38 | <0.1 | <0.01 |
| show processlist | 32 | <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 | 18 | <0.1 | <0.01 |
| show databases | 14 | <0.1 | <0.01 |
| grant | 9 | <0.1 | <0.01 |
| truncate | 9 | <0.1 | <0.01 |