| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,184 k | 71.3 k | 76.24 |
| show tables | 152 k | 4,946.8 | 5.29 |
| show fields | 144 k | 4,712.3 | 5.04 |
| change db | 105 k | 3,419.5 | 3.66 |
| show keys | 71,591 | 2,335.9 | 2.50 |
| set option | 64,959 | 2,119.6 | 2.27 |
| show variables | 28,198 | 920.1 | 0.98 |
| replace | 25,891 | 844.8 | 0.90 |
| show create table | 17,890 | 583.7 | 0.62 |
| stmt execute | 17,105 | 558.1 | 0.60 |
| stmt close | 16,706 | 545.1 | 0.58 |
| stmt prepare | 16,706 | 545.1 | 0.58 |
| show warnings | 12,014 | 392 | 0.42 |
| show storage engines | 2,865 | 93.5 | 0.10 |
| update | 1,813 | 59.2 | 0.06 |
| insert | 962 | 31.4 | 0.03 |
| show grants | 863 | 28.2 | 0.03 |
| alter table | 736 | 24 | 0.03 |
| show binlogs | 422 | 13.8 | 0.01 |
| show table status | 272 | 8.9 | 0.01 |
| show slave status | 246 | 8 | 0.01 |
| show master status | 227 | 7.4 | 0.01 |
| begin | 109 | 3.6 | <0.01 |
| commit | 90 | 2.9 | <0.01 |
| delete | 65 | 2.1 | <0.01 |
| show status | 46 | 1.5 | <0.01 |
| create table | 33 | 1.1 | <0.01 |
| rollback | 18 | 0.6 | <0.01 |
| show engine status | 6 | 0.2 | <0.01 |
| show processlist | 6 | 0.2 | <0.01 |
| flush | 4 | 0.1 | <0.01 |