| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 3,509 k | 97.2 k | 79.91 |
| show fields | 219 k | 6,076.7 | 4.99 |
| show tables | 184 k | 5,104.8 | 4.19 |
| change db | 147 k | 4,072.5 | 3.35 |
| set option | 110 k | 3,058.2 | 2.51 |
| show variables | 72,258 | 2,002.4 | 1.65 |
| show keys | 37,145 | 1,029.4 | 0.85 |
| show grants | 36,223 | 1,003.8 | 0.82 |
| show create table | 36,200 | 1,003.2 | 0.82 |
| show warnings | 36,060 | 999.3 | 0.82 |
| replace | 3,009 | 83.4 | 0.07 |
| show binlogs | 132 | 3.7 | <0.01 |
| show storage engines | 75 | 2.1 | <0.01 |
| stmt prepare | 66 | 1.8 | <0.01 |
| update | 65 | 1.8 | <0.01 |
| show slave status | 41 | 1.1 | <0.01 |
| show master status | 38 | 1.1 | <0.01 |
| stmt close | 36 | 1 | <0.01 |
| stmt execute | 36 | 1 | <0.01 |
| show table status | 25 | 0.7 | <0.01 |
| show status | 22 | 0.6 | <0.01 |
| show processlist | 3 | 0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |