| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,119 k | 71.7 k | 76.63 |
| show tables | 145 k | 4,920.6 | 5.26 |
| show fields | 140 k | 4,744.8 | 5.07 |
| change db | 102 k | 3,435.4 | 3.67 |
| show keys | 69,752 | 2,360.4 | 2.52 |
| set option | 59,982 | 2,029.8 | 2.17 |
| show variables | 27,737 | 938.6 | 1.00 |
| replace | 25,365 | 858.3 | 0.92 |
| show create table | 17,554 | 594 | 0.63 |
| stmt execute | 13,222 | 447.4 | 0.48 |
| stmt close | 12,848 | 434.8 | 0.46 |
| stmt prepare | 12,848 | 434.8 | 0.46 |
| show warnings | 11,922 | 403.4 | 0.43 |
| show storage engines | 2,742 | 92.8 | 0.10 |
| update | 1,473 | 49.8 | 0.05 |
| insert | 772 | 26.1 | 0.03 |
| show grants | 694 | 23.5 | 0.03 |
| alter table | 613 | 20.7 | 0.02 |
| show binlogs | 355 | 12 | 0.01 |
| show table status | 252 | 8.5 | 0.01 |
| show slave status | 232 | 7.9 | 0.01 |
| show master status | 213 | 7.2 | 0.01 |
| begin | 86 | 2.9 | <0.01 |
| commit | 74 | 2.5 | <0.01 |
| delete | 56 | 1.9 | <0.01 |
| show status | 34 | 1.2 | <0.01 |
| create table | 32 | 1.1 | <0.01 |
| rollback | 12 | 0.4 | <0.01 |
| show engine status | 4 | 0.1 | <0.01 |
| show processlist | 4 | 0.1 | <0.01 |
| flush | 3 | 0.1 | <0.01 |