| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,326 k | 706.5 | 64.07 |
| set option | 180 k | 96.1 | 8.71 |
| show fields | 146 k | 77.8 | 7.06 |
| show keys | 114 k | 60.7 | 5.51 |
| change db | 64,573 | 34.4 | 3.12 |
| replace | 58,596 | 31.2 | 2.83 |
| show tables | 52,204 | 27.8 | 2.52 |
| show variables | 46,512 | 24.8 | 2.25 |
| show create table | 38,570 | 20.5 | 1.86 |
| show warnings | 16,942 | 9 | 0.82 |
| show storage engines | 11,717 | 6.2 | 0.57 |
| show table status | 5,810 | 3.1 | 0.28 |
| show grants | 2,100 | 1.1 | 0.10 |
| stmt close | 1,364 | 0.7 | 0.07 |
| stmt execute | 1,364 | 0.7 | 0.07 |
| stmt prepare | 1,364 | 0.7 | 0.07 |
| show binlogs | 831 | 0.4 | 0.04 |
| delete | 761 | 0.4 | 0.04 |
| show slave status | 201 | 0.1 | 0.01 |
| show master status | 193 | 0.1 | 0.01 |
| show status | 55 | <0.1 | <0.01 |
| show processlist | 8 | <0.1 | <0.01 |
| show engine status | 6 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |