| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,237 k | 3,442.9 | 77.95 |
| show tables | 151 k | 232.6 | 5.27 |
| show fields | 141 k | 217 | 4.91 |
| change db | 112 k | 171.7 | 3.89 |
| set option | 100 k | 154 | 3.49 |
| show keys | 48,920 | 75.3 | 1.70 |
| replace | 24,837 | 38.2 | 0.87 |
| show variables | 20,217 | 31.1 | 0.70 |
| show create table | 17,375 | 26.7 | 0.61 |
| show warnings | 7,780 | 12 | 0.27 |
| show storage engines | 5,119 | 7.9 | 0.18 |
| stmt close | 763 | 1.2 | 0.03 |
| stmt execute | 763 | 1.2 | 0.03 |
| stmt prepare | 763 | 1.2 | 0.03 |
| insert | 561 | 0.9 | 0.02 |
| show table status | 561 | 0.9 | 0.02 |
| show grants | 337 | 0.5 | 0.01 |
| show binlogs | 294 | 0.5 | 0.01 |
| update | 235 | 0.4 | 0.01 |
| insert select | 175 | 0.3 | 0.01 |
| show slave status | 143 | 0.2 | <0.01 |
| show master status | 136 | 0.2 | <0.01 |
| delete | 75 | 0.1 | <0.01 |
| show status | 23 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |