| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,768 k | 760.4 | 72.35 |
| show keys | 205 k | 56.3 | 5.36 |
| show fields | 203 k | 55.7 | 5.30 |
| set option | 188 k | 51.7 | 4.92 |
| change db | 122 k | 33.5 | 3.19 |
| show tables | 93,613 | 25.7 | 2.45 |
| show variables | 72,558 | 19.9 | 1.90 |
| show grants | 49,522 | 13.6 | 1.29 |
| show create table | 45,134 | 12.4 | 1.18 |
| replace | 38,433 | 10.6 | 1.00 |
| show warnings | 31,616 | 8.7 | 0.83 |
| show storage engines | 4,001 | 1.1 | 0.10 |
| show binlogs | 2,362 | 0.6 | 0.06 |
| show slave status | 825 | 0.2 | 0.02 |
| show master status | 792 | 0.2 | 0.02 |
| show table status | 344 | 0.1 | 0.01 |
| update | 303 | 0.1 | 0.01 |
| show status | 142 | <0.1 | <0.01 |
| show processlist | 21 | <0.1 | <0.01 |
| flush | 11 | <0.1 | <0.01 |
| show engine status | 6 | <0.1 | <0.01 |
| show databases | 3 | <0.1 | <0.01 |
| insert | 1 | <0.1 | <0.01 |