| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,335 k | 3,575.3 | 77.86 |
| show tables | 158 k | 241.7 | 5.26 |
| show fields | 149 k | 228.4 | 4.97 |
| change db | 117 k | 179.3 | 3.90 |
| set option | 104 k | 158.9 | 3.46 |
| show keys | 52,312 | 80.1 | 1.74 |
| replace | 25,585 | 39.2 | 0.85 |
| show variables | 20,637 | 31.6 | 0.69 |
| show create table | 18,666 | 28.6 | 0.62 |
| show warnings | 7,799 | 11.9 | 0.26 |
| show storage engines | 5,384 | 8.2 | 0.18 |
| stmt close | 851 | 1.3 | 0.03 |
| stmt execute | 851 | 1.3 | 0.03 |
| stmt prepare | 851 | 1.3 | 0.03 |
| show grants | 779 | 1.2 | 0.03 |
| show table status | 607 | 0.9 | 0.02 |
| insert | 566 | 0.9 | 0.02 |
| show binlogs | 389 | 0.6 | 0.01 |
| update | 243 | 0.4 | 0.01 |
| show slave status | 179 | 0.3 | 0.01 |
| insert select | 175 | 0.3 | 0.01 |
| show master status | 170 | 0.3 | 0.01 |
| delete | 78 | 0.1 | <0.01 |
| show status | 53 | 0.1 | <0.01 |
| show processlist | 7 | <0.1 | <0.01 |
| show engine status | 4 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |