| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 698 k | 1,808.6 | 78.27 |
| show tables | 51,015 | 132.3 | 5.72 |
| show fields | 43,226 | 112.1 | 4.85 |
| change db | 34,638 | 89.8 | 3.89 |
| set option | 25,536 | 66.2 | 2.86 |
| show keys | 15,335 | 39.8 | 1.72 |
| replace | 6,346 | 16.5 | 0.71 |
| show create table | 4,652 | 12.1 | 0.52 |
| show variables | 4,517 | 11.7 | 0.51 |
| show grants | 2,763 | 7.2 | 0.31 |
| show storage engines | 1,558 | 4 | 0.17 |
| show warnings | 1,314 | 3.4 | 0.15 |
| stmt prepare | 671 | 1.7 | 0.08 |
| stmt close | 456 | 1.2 | 0.05 |
| stmt execute | 456 | 1.2 | 0.05 |
| insert | 324 | 0.8 | 0.04 |
| show binlogs | 235 | 0.6 | 0.03 |
| show slave status | 222 | 0.6 | 0.02 |
| show master status | 212 | 0.5 | 0.02 |
| show table status | 192 | 0.5 | 0.02 |
| show status | 43 | 0.1 | <0.01 |
| flush | 5 | <0.1 | <0.01 |
| show processlist | 5 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |