| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,548 k | 1,489.1 | 77.76 |
| show tables | 106 k | 102.4 | 5.35 |
| show fields | 97,311 | 93.6 | 4.89 |
| change db | 75,365 | 72.5 | 3.79 |
| set option | 57,177 | 55 | 2.87 |
| show keys | 48,480 | 46.6 | 2.44 |
| show variables | 16,391 | 15.8 | 0.82 |
| replace | 14,094 | 13.6 | 0.71 |
| show create table | 10,471 | 10.1 | 0.53 |
| show warnings | 6,551 | 6.3 | 0.33 |
| show grants | 4,374 | 4.2 | 0.22 |
| show storage engines | 2,098 | 2 | 0.11 |
| show binlogs | 906 | 0.9 | 0.05 |
| stmt close | 623 | 0.6 | 0.03 |
| stmt execute | 623 | 0.6 | 0.03 |
| stmt prepare | 623 | 0.6 | 0.03 |
| update | 451 | 0.4 | 0.02 |
| show slave status | 305 | 0.3 | 0.02 |
| show master status | 291 | 0.3 | 0.01 |
| show table status | 187 | 0.2 | 0.01 |
| show status | 70 | 0.1 | <0.01 |
| show processlist | 10 | <0.1 | <0.01 |
| flush | 6 | <0.1 | <0.01 |
| show engine status | 6 | <0.1 | <0.01 |
| insert | 1 | <0.1 | <0.01 |