控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,222 k | 480.3 | 79.92 |
| show fields | 115 k | 24.8 | 4.12 |
| show tables | 102 k | 22 | 3.65 |
| change db | 82,963 | 17.9 | 2.98 |
| set option | 76,008 | 16.4 | 2.73 |
| show keys | 44,982 | 9.7 | 1.62 |
| show variables | 30,462 | 6.6 | 1.10 |
| update | 22,194 | 4.8 | 0.80 |
| show grants | 18,157 | 3.9 | 0.65 |
| show create table | 16,316 | 3.5 | 0.59 |
| show warnings | 14,450 | 3.1 | 0.52 |
| replace | 14,068 | 3 | 0.51 |
| insert | 10,430 | 2.3 | 0.38 |
| delete | 8,417 | 1.8 | 0.30 |
| show binlogs | 743 | 0.2 | 0.03 |
| show storage engines | 697 | 0.2 | 0.03 |
| delete multi | 573 | 0.1 | 0.02 |
| insert select | 410 | 0.1 | 0.01 |
| stmt prepare | 316 | 0.1 | 0.01 |
| stmt close | 191 | <0.1 | 0.01 |
| stmt execute | 191 | <0.1 | 0.01 |
| show table status | 188 | <0.1 | 0.01 |
| show slave status | 158 | <0.1 | 0.01 |
| show master status | 148 | <0.1 | 0.01 |
| alter table | 52 | <0.1 | <0.01 |
| show status | 50 | <0.1 | <0.01 |
| create table | 28 | <0.1 | <0.01 |
| show engine status | 20 | <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 |