| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 396 k | 1,955 | 43.71 |
| stmt execute | 106 k | 521.9 | 11.67 |
| stmt prepare | 103 k | 508.1 | 11.36 |
| stmt close | 103 k | 508.1 | 11.36 |
| set option | 81,149 | 400.8 | 8.96 |
| show tables | 47,273 | 233.5 | 5.22 |
| show fields | 15,847 | 78.3 | 1.75 |
| change db | 14,634 | 72.3 | 1.62 |
| update | 13,473 | 66.5 | 1.49 |
| insert | 6,677 | 33 | 0.74 |
| alter table | 4,646 | 22.9 | 0.51 |
| show keys | 4,012 | 19.8 | 0.44 |
| show variables | 2,373 | 11.7 | 0.26 |
| show grants | 1,754 | 8.7 | 0.19 |
| replace | 1,408 | 7 | 0.16 |
| show create table | 963 | 4.8 | 0.11 |
| begin | 771 | 3.8 | 0.09 |
| show binlogs | 702 | 3.5 | 0.08 |
| commit | 670 | 3.3 | 0.07 |
| delete | 668 | 3.3 | 0.07 |
| show storage engines | 397 | 2 | 0.04 |
| show warnings | 313 | 1.5 | 0.03 |
| create table | 171 | 0.8 | 0.02 |
| show slave status | 132 | 0.7 | 0.01 |
| show master status | 124 | 0.6 | 0.01 |
| show table status | 97 | 0.5 | 0.01 |
| rollback | 90 | 0.4 | 0.01 |
| show status | 28 | 0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |