| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,316 k | 3,553.3 | 77.89 |
| show tables | 156 k | 239.8 | 5.26 |
| show fields | 147 k | 226 | 4.95 |
| change db | 116 k | 178.2 | 3.91 |
| set option | 103 k | 158.2 | 3.47 |
| show keys | 51,156 | 78.5 | 1.72 |
| replace | 25,529 | 39.2 | 0.86 |
| show variables | 20,539 | 31.5 | 0.69 |
| show create table | 18,591 | 28.5 | 0.63 |
| show warnings | 7,792 | 12 | 0.26 |
| show storage engines | 5,364 | 8.2 | 0.18 |
| stmt close | 840 | 1.3 | 0.03 |
| stmt execute | 840 | 1.3 | 0.03 |
| stmt prepare | 840 | 1.3 | 0.03 |
| show grants | 681 | 1 | 0.02 |
| show table status | 586 | 0.9 | 0.02 |
| insert | 566 | 0.9 | 0.02 |
| show binlogs | 345 | 0.5 | 0.01 |
| update | 243 | 0.4 | 0.01 |
| insert select | 175 | 0.3 | 0.01 |
| show slave status | 165 | 0.3 | 0.01 |
| show master status | 156 | 0.2 | 0.01 |
| delete | 78 | 0.1 | <0.01 |
| show status | 36 | 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 |