| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 5,873 k | 1,681.6 | 77.76 |
| show tables | 396 k | 113.4 | 5.24 |
| show fields | 373 k | 106.8 | 4.94 |
| change db | 285 k | 81.5 | 3.77 |
| set option | 213 k | 61.1 | 2.82 |
| show keys | 181 k | 51.9 | 2.40 |
| show variables | 68,654 | 19.7 | 0.91 |
| replace | 47,425 | 13.6 | 0.63 |
| show create table | 40,045 | 11.5 | 0.53 |
| show warnings | 27,560 | 7.9 | 0.36 |
| show grants | 19,696 | 5.6 | 0.26 |
| show storage engines | 7,541 | 2.2 | 0.10 |
| show binlogs | 5,053 | 1.4 | 0.07 |
| stmt close | 3,509 | 1 | 0.05 |
| stmt execute | 3,509 | 1 | 0.05 |
| stmt prepare | 3,509 | 1 | 0.05 |
| show slave status | 1,475 | 0.4 | 0.02 |
| show master status | 1,274 | 0.4 | 0.02 |
| show table status | 1,001 | 0.3 | 0.01 |
| update | 911 | 0.3 | 0.01 |
| show status | 277 | 0.1 | <0.01 |
| show processlist | 26 | <0.1 | <0.01 |
| flush | 25 | <0.1 | <0.01 |
| show engine status | 16 | <0.1 | <0.01 |
| insert | 1 | <0.1 | <0.01 |