控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 26,535 k | 4,642.6 | 77.69 |
| show tables | 1,850 k | 323.7 | 5.42 |
| change db | 1,466 k | 256.6 | 4.29 |
| show fields | 1,282 k | 224.4 | 3.75 |
| show variables | 1,256 k | 219.8 | 3.68 |
| set option | 1,098 k | 192.2 | 3.22 |
| show warnings | 335 k | 58.7 | 0.98 |
| show keys | 151 k | 26.4 | 0.44 |
| show grants | 73,206 | 12.8 | 0.21 |
| show create table | 57,737 | 10.1 | 0.17 |
| replace | 28,646 | 5 | 0.08 |
| show binlogs | 8,643 | 1.5 | 0.03 |
| show storage engines | 3,281 | 0.6 | 0.01 |
| stmt prepare | 2,464 | 0.4 | 0.01 |
| stmt close | 1,459 | 0.3 | <0.01 |
| stmt execute | 1,459 | 0.3 | <0.01 |
| show slave status | 1,456 | 0.3 | <0.01 |
| show master status | 1,389 | 0.2 | <0.01 |
| show table status | 697 | 0.1 | <0.01 |
| update | 368 | 0.1 | <0.01 |
| show status | 308 | 0.1 | <0.01 |
| flush | 40 | <0.1 | <0.01 |
| show processlist | 35 | <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 |
| show engine status | 20 | <0.1 | <0.01 |
| reset | 18 | <0.1 | <0.01 |
| show databases | 14 | <0.1 | <0.01 |
| grant | 9 | <0.1 | <0.01 |
| truncate | 9 | <0.1 | <0.01 |