控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,225 k | 479 | 79.92 |
| show fields | 115 k | 24.7 | 4.12 |
| show tables | 102 k | 21.9 | 3.65 |
| change db | 83,058 | 17.9 | 2.98 |
| set option | 76,095 | 16.4 | 2.73 |
| show keys | 45,073 | 9.7 | 1.62 |
| show variables | 30,480 | 6.6 | 1.09 |
| update | 22,229 | 4.8 | 0.80 |
| show grants | 18,181 | 3.9 | 0.65 |
| show create table | 16,318 | 3.5 | 0.59 |
| show warnings | 14,452 | 3.1 | 0.52 |
| replace | 14,070 | 3 | 0.51 |
| insert | 10,442 | 2.2 | 0.38 |
| delete | 8,435 | 1.8 | 0.30 |
| show binlogs | 763 | 0.2 | 0.03 |
| show storage engines | 703 | 0.2 | 0.03 |
| delete multi | 573 | 0.1 | 0.02 |
| insert select | 410 | 0.1 | 0.01 |
| stmt prepare | 327 | 0.1 | 0.01 |
| stmt close | 197 | <0.1 | 0.01 |
| stmt execute | 197 | <0.1 | 0.01 |
| show table status | 189 | <0.1 | 0.01 |
| show slave status | 160 | <0.1 | 0.01 |
| show master status | 150 | <0.1 | 0.01 |
| alter table | 52 | <0.1 | <0.01 |
| show status | 52 | <0.1 | <0.01 |
| create table | 28 | <0.1 | <0.01 |
| show engine status | 22 | <0.1 | <0.01 |
| show processlist | 5 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |
| begin | 1 | <0.1 | <0.01 |
| commit | 1 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| drop table | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |