| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,127 k | 1,707.9 | 78.56 |
| show tables | 82,454 | 125 | 5.75 |
| show fields | 67,070 | 101.7 | 4.68 |
| change db | 55,691 | 84.4 | 3.88 |
| set option | 41,253 | 62.5 | 2.88 |
| show keys | 21,165 | 32.1 | 1.48 |
| replace | 10,360 | 15.7 | 0.72 |
| show variables | 7,821 | 11.9 | 0.55 |
| show grants | 6,973 | 10.6 | 0.49 |
| show create table | 6,459 | 9.8 | 0.45 |
| show storage engines | 2,079 | 3.2 | 0.14 |
| show warnings | 2,075 | 3.1 | 0.14 |
| stmt prepare | 1,006 | 1.5 | 0.07 |
| stmt close | 706 | 1.1 | 0.05 |
| stmt execute | 706 | 1.1 | 0.05 |
| show binlogs | 516 | 0.8 | 0.04 |
| show table status | 309 | 0.5 | 0.02 |
| show slave status | 249 | 0.4 | 0.02 |
| insert | 242 | 0.4 | 0.02 |
| show master status | 237 | 0.4 | 0.02 |
| show status | 58 | 0.1 | <0.01 |
| show processlist | 8 | <0.1 | <0.01 |
| show engine status | 7 | <0.1 | <0.01 |
| flush | 6 | <0.1 | <0.01 |