| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 170 M | 1,096.1 k | 79.54 |
| show fields | 9,210 k | 59.4 k | 4.31 |
| show tables | 7,681 k | 49.5 k | 3.59 |
| show keys | 7,668 k | 49.4 k | 3.59 |
| change db | 6,143 k | 39.6 k | 2.87 |
| set option | 4,607 k | 29.7 k | 2.16 |
| show variables | 3,067 k | 19.8 k | 1.43 |
| show create table | 1,534 k | 9,886.4 | 0.72 |
| show grants | 1,533 k | 9,885.4 | 0.72 |
| show warnings | 1,533 k | 9,882.2 | 0.72 |
| replace | 762 k | 4,913 | 0.36 |
| show binlogs | 450 | 2.9 | <0.01 |
| stmt prepare | 341 | 2.2 | <0.01 |
| show storage engines | 313 | 2 | <0.01 |
| stmt close | 186 | 1.2 | <0.01 |
| stmt execute | 186 | 1.2 | <0.01 |
| show slave status | 81 | 0.5 | <0.01 |
| show master status | 76 | 0.5 | <0.01 |
| show table status | 70 | 0.5 | <0.01 |
| show status | 38 | 0.2 | <0.01 |
| show processlist | 5 | <0.1 | <0.01 |
| flush | 4 | <0.1 | <0.01 |
| show engine status | 4 | <0.1 | <0.01 |