| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 325 M | 1,231.8 k | 80.21 |
| show fields | 17,358 k | 65.9 k | 4.29 |
| show tables | 13,894 k | 52.7 k | 3.43 |
| show keys | 13,455 k | 51.1 k | 3.33 |
| change db | 11,073 k | 42 k | 2.74 |
| set option | 8,188 k | 31.1 k | 2.02 |
| show variables | 5,529 k | 21 k | 1.37 |
| show grants | 2,765 k | 10.5 k | 0.68 |
| show create table | 2,763 k | 10.5 k | 0.68 |
| show warnings | 2,762 k | 10.5 k | 0.68 |
| replace | 1,688 k | 6,408.9 | 0.42 |
| stmt execute | 180 k | 683.4 | 0.04 |
| stmt prepare | 176 k | 666.8 | 0.04 |
| stmt close | 176 k | 666.7 | 0.04 |
| update | 22,008 | 83.5 | 0.01 |
| insert | 11,122 | 42.2 | <0.01 |
| alter table | 4,898 | 18.6 | <0.01 |
| show binlogs | 2,251 | 8.5 | <0.01 |
| begin | 1,295 | 4.9 | <0.01 |
| commit | 1,111 | 4.2 | <0.01 |
| delete | 1,033 | 3.9 | <0.01 |
| create table | 407 | 1.5 | <0.01 |
| show storage engines | 354 | 1.3 | <0.01 |
| rollback | 158 | 0.6 | <0.01 |
| show slave status | 95 | 0.4 | <0.01 |
| show master status | 89 | 0.3 | <0.01 |
| show table status | 70 | 0.3 | <0.01 |
| show status | 18 | 0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |