| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 9,793 k | 69.5 k | 79.97 |
| show fields | 559 k | 3,966.9 | 4.57 |
| show tables | 494 k | 3,508 | 4.04 |
| change db | 388 k | 2,755.6 | 3.17 |
| set option | 327 k | 2,323 | 2.67 |
| show keys | 291 k | 2,061.9 | 2.37 |
| show variables | 143 k | 1,012.8 | 1.17 |
| replace | 80,530 | 571.3 | 0.66 |
| show create table | 76,704 | 544.2 | 0.63 |
| show warnings | 68,149 | 483.5 | 0.56 |
| show grants | 10,661 | 75.6 | 0.09 |
| show storage engines | 3,910 | 27.7 | 0.03 |
| update | 3,595 | 25.5 | 0.03 |
| stmt close | 908 | 6.4 | 0.01 |
| stmt execute | 908 | 6.4 | 0.01 |
| stmt prepare | 908 | 6.4 | 0.01 |
| show binlogs | 826 | 5.9 | 0.01 |
| insert | 567 | 4 | <0.01 |
| delete | 564 | 4 | <0.01 |
| show table status | 511 | 3.6 | <0.01 |
| show slave status | 389 | 2.8 | <0.01 |
| show master status | 368 | 2.6 | <0.01 |
| show status | 92 | 0.7 | <0.01 |
| show processlist | 12 | 0.1 | <0.01 |
| flush | 7 | <0.1 | <0.01 |
| show engine status | 5 | <0.1 | <0.01 |