| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,783 k | 810.8 | 73.26 |
| show keys | 141 k | 64.3 | 5.81 |
| show fields | 126 k | 57.5 | 5.19 |
| set option | 106 k | 48.2 | 4.36 |
| change db | 69,866 | 31.8 | 2.87 |
| show variables | 54,919 | 25 | 2.26 |
| show tables | 43,143 | 19.6 | 1.77 |
| show grants | 31,651 | 14.4 | 1.30 |
| show create table | 29,910 | 13.6 | 1.23 |
| show warnings | 26,010 | 11.8 | 1.07 |
| replace | 18,428 | 8.4 | 0.76 |
| show storage engines | 1,206 | 0.5 | 0.05 |
| show binlogs | 891 | 0.4 | 0.04 |
| show slave status | 285 | 0.1 | 0.01 |
| show master status | 272 | 0.1 | 0.01 |
| show table status | 124 | 0.1 | 0.01 |
| update | 107 | <0.1 | <0.01 |
| show status | 51 | <0.1 | <0.01 |
| show processlist | 9 | <0.1 | <0.01 |
| show databases | 3 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| insert | 1 | <0.1 | <0.01 |