| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 337 k | 1,675.2 | 40.64 |
| stmt execute | 105 k | 524.6 | 12.72 |
| stmt prepare | 103 k | 510.8 | 12.39 |
| stmt close | 103 k | 510.7 | 12.39 |
| set option | 79,604 | 396.3 | 9.61 |
| show tables | 43,034 | 214.2 | 5.20 |
| update | 13,431 | 66.9 | 1.62 |
| show fields | 11,798 | 58.7 | 1.42 |
| change db | 11,270 | 56.1 | 1.36 |
| insert | 6,655 | 33.1 | 0.80 |
| alter table | 4,631 | 23.1 | 0.56 |
| show variables | 1,969 | 9.8 | 0.24 |
| show keys | 1,856 | 9.2 | 0.22 |
| show grants | 1,530 | 7.6 | 0.18 |
| replace | 914 | 4.6 | 0.11 |
| begin | 767 | 3.8 | 0.09 |
| commit | 666 | 3.3 | 0.08 |
| delete | 664 | 3.3 | 0.08 |
| show binlogs | 627 | 3.1 | 0.08 |
| show create table | 616 | 3.1 | 0.07 |
| show warnings | 264 | 1.3 | 0.03 |
| show storage engines | 217 | 1.1 | 0.03 |
| create table | 156 | 0.8 | 0.02 |
| show slave status | 104 | 0.5 | 0.01 |
| show master status | 98 | 0.5 | 0.01 |
| rollback | 90 | 0.4 | 0.01 |
| show table status | 53 | 0.3 | 0.01 |
| show status | 11 | 0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |