| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 308 k | 24.6 k | 78.07 |
| show tables | 22,501 | 1,798 | 5.71 |
| show fields | 19,385 | 1,549 | 4.92 |
| change db | 16,502 | 1,318.7 | 4.19 |
| set option | 11,362 | 907.9 | 2.88 |
| show keys | 6,991 | 558.6 | 1.77 |
| show variables | 2,761 | 220.6 | 0.70 |
| replace | 2,738 | 218.8 | 0.69 |
| show create table | 1,833 | 146.5 | 0.47 |
| show grants | 589 | 47.1 | 0.15 |
| show storage engines | 509 | 40.7 | 0.13 |
| show warnings | 457 | 36.5 | 0.12 |
| show table status | 217 | 17.3 | 0.06 |
| show binlogs | 207 | 16.5 | 0.05 |
| stmt prepare | 130 | 10.4 | 0.03 |
| stmt close | 70 | 5.6 | 0.02 |
| stmt execute | 70 | 5.6 | 0.02 |
| show slave status | 48 | 3.8 | 0.01 |
| show master status | 45 | 3.6 | 0.01 |
| show status | 21 | 1.7 | 0.01 |
| show processlist | 3 | 0.2 | <0.01 |
| flush | 1 | 0.1 | <0.01 |
| show databases | 1 | 0.1 | <0.01 |
| show engine status | 1 | 0.1 | <0.01 |