| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 166 M | 1,095.2 k | 79.54 |
| show fields | 8,990 k | 59.3 k | 4.31 |
| show tables | 7,494 k | 49.4 k | 3.59 |
| show keys | 7,490 k | 49.4 k | 3.59 |
| change db | 5,995 k | 39.6 k | 2.87 |
| set option | 4,496 k | 29.7 k | 2.15 |
| show variables | 2,997 k | 19.8 k | 1.44 |
| show grants | 1,498 k | 9,884.2 | 0.72 |
| show create table | 1,498 k | 9,882.9 | 0.72 |
| show warnings | 1,498 k | 9,882.8 | 0.72 |
| replace | 743 k | 4,900.2 | 0.36 |
| show binlogs | 211 | 1.4 | <0.01 |
| stmt prepare | 121 | 0.8 | <0.01 |
| stmt close | 66 | 0.4 | <0.01 |
| stmt execute | 66 | 0.4 | <0.01 |
| show slave status | 53 | 0.3 | <0.01 |
| show master status | 50 | 0.3 | <0.01 |
| show storage engines | 40 | 0.3 | <0.01 |
| show table status | 19 | 0.1 | <0.01 |
| show status | 16 | 0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |