| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,280 k | 3,500.8 | 77.90 |
| show tables | 154 k | 236.1 | 5.25 |
| show fields | 145 k | 222.1 | 4.94 |
| change db | 114 k | 175.2 | 3.90 |
| set option | 102 k | 156.3 | 3.48 |
| show keys | 50,502 | 77.6 | 1.73 |
| replace | 25,149 | 38.6 | 0.86 |
| show variables | 20,450 | 31.4 | 0.70 |
| show create table | 18,005 | 27.7 | 0.62 |
| show warnings | 7,785 | 12 | 0.27 |
| show storage engines | 5,295 | 8.1 | 0.18 |
| stmt close | 829 | 1.3 | 0.03 |
| stmt execute | 829 | 1.3 | 0.03 |
| stmt prepare | 829 | 1.3 | 0.03 |
| show table status | 583 | 0.9 | 0.02 |
| insert | 566 | 0.9 | 0.02 |
| show grants | 507 | 0.8 | 0.02 |
| show binlogs | 329 | 0.5 | 0.01 |
| update | 243 | 0.4 | 0.01 |
| insert select | 175 | 0.3 | 0.01 |
| show slave status | 163 | 0.3 | 0.01 |
| show master status | 154 | 0.2 | 0.01 |
| delete | 78 | 0.1 | <0.01 |
| show status | 34 | 0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |