| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 738 k | 1,741.4 | 78.87 |
| show tables | 51,319 | 121.1 | 5.48 |
| show fields | 44,425 | 104.8 | 4.75 |
| change db | 35,769 | 84.4 | 3.82 |
| set option | 27,460 | 64.8 | 2.93 |
| show keys | 16,324 | 38.5 | 1.74 |
| show variables | 6,582 | 15.5 | 0.70 |
| replace | 5,624 | 13.3 | 0.60 |
| show create table | 4,199 | 9.9 | 0.45 |
| show warnings | 2,290 | 5.4 | 0.24 |
| show storage engines | 1,042 | 2.5 | 0.11 |
| show grants | 542 | 1.3 | 0.06 |
| show binlogs | 375 | 0.9 | 0.04 |
| stmt prepare | 352 | 0.8 | 0.04 |
| update | 270 | 0.6 | 0.03 |
| stmt close | 247 | 0.6 | 0.03 |
| stmt execute | 247 | 0.6 | 0.03 |
| insert | 230 | 0.5 | 0.02 |
| show table status | 158 | 0.4 | 0.02 |
| show slave status | 122 | 0.3 | 0.01 |
| show master status | 116 | 0.3 | 0.01 |
| show status | 32 | 0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |