| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,865 k | 786.2 | 71.91 |
| show keys | 217 k | 59.5 | 5.44 |
| show fields | 214 k | 58.7 | 5.37 |
| set option | 202 k | 55.4 | 5.06 |
| change db | 129 k | 35.3 | 3.23 |
| show tables | 99,366 | 27.3 | 2.49 |
| show variables | 75,768 | 20.8 | 1.90 |
| show grants | 50,153 | 13.8 | 1.26 |
| show create table | 48,030 | 13.2 | 1.21 |
| replace | 42,139 | 11.6 | 1.06 |
| show warnings | 32,604 | 8.9 | 0.82 |
| show storage engines | 4,582 | 1.3 | 0.12 |
| show binlogs | 2,496 | 0.7 | 0.06 |
| show slave status | 893 | 0.2 | 0.02 |
| show master status | 858 | 0.2 | 0.02 |
| show table status | 399 | 0.1 | 0.01 |
| update | 304 | 0.1 | 0.01 |
| show status | 168 | <0.1 | <0.01 |
| show processlist | 24 | <0.1 | <0.01 |
| flush | 13 | <0.1 | <0.01 |
| show engine status | 7 | <0.1 | <0.01 |
| show databases | 3 | <0.1 | <0.01 |
| insert | 1 | <0.1 | <0.01 |