| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,828 k | 830.6 | 72.98 |
| show keys | 147 k | 66.7 | 5.86 |
| show fields | 131 k | 59.7 | 5.25 |
| set option | 112 k | 50.8 | 4.46 |
| change db | 72,968 | 33.2 | 2.91 |
| show variables | 56,338 | 25.6 | 2.25 |
| show tables | 44,928 | 20.4 | 1.79 |
| show grants | 32,000 | 14.5 | 1.28 |
| show create table | 31,114 | 14.1 | 1.24 |
| show warnings | 26,321 | 12 | 1.05 |
| replace | 19,642 | 8.9 | 0.78 |
| show storage engines | 1,512 | 0.7 | 0.06 |
| show binlogs | 1,014 | 0.5 | 0.04 |
| show slave status | 333 | 0.2 | 0.01 |
| show master status | 318 | 0.1 | 0.01 |
| show table status | 155 | 0.1 | 0.01 |
| update | 107 | <0.1 | <0.01 |
| show status | 69 | <0.1 | <0.01 |
| show processlist | 11 | <0.1 | <0.01 |
| flush | 4 | <0.1 | <0.01 |
| show databases | 3 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| insert | 1 | <0.1 | <0.01 |