| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,193 k | 2,015.4 | 78.93 |
| show tables | 87,670 | 148.1 | 5.80 |
| change db | 69,559 | 117.5 | 4.60 |
| show fields | 52,902 | 89.4 | 3.50 |
| set option | 52,172 | 88.2 | 3.45 |
| show variables | 45,800 | 77.4 | 3.03 |
| stmt prepare | 2,291 | 3.9 | 0.15 |
| show grants | 1,938 | 3.3 | 0.13 |
| show binlogs | 1,696 | 2.9 | 0.11 |
| stmt execute | 1,251 | 2.1 | 0.08 |
| stmt close | 1,251 | 2.1 | 0.08 |
| show keys | 715 | 1.2 | 0.05 |
| show slave status | 390 | 0.7 | 0.03 |
| show master status | 387 | 0.7 | 0.03 |
| show warnings | 109 | 0.2 | 0.01 |
| show create table | 108 | 0.2 | 0.01 |
| replace | 62 | 0.1 | <0.01 |
| show table status | 37 | 0.1 | <0.01 |
| show storage engines | 28 | <0.1 | <0.01 |
| show status | 13 | <0.1 | <0.01 |
| update | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |