| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,017 k | 1,362.1 | 78.81 |
| show tables | 148 k | 100.3 | 5.80 |
| show fields | 119 k | 80.3 | 4.65 |
| change db | 98,683 | 66.6 | 3.86 |
| set option | 75,198 | 50.8 | 2.94 |
| show keys | 37,176 | 25.1 | 1.45 |
| replace | 16,239 | 11 | 0.63 |
| show variables | 12,386 | 8.4 | 0.48 |
| show create table | 10,951 | 7.4 | 0.43 |
| show grants | 9,567 | 6.5 | 0.37 |
| show storage engines | 3,536 | 2.4 | 0.14 |
| show warnings | 3,416 | 2.3 | 0.13 |
| stmt prepare | 1,567 | 1.1 | 0.06 |
| show binlogs | 1,469 | 1 | 0.06 |
| stmt close | 1,077 | 0.7 | 0.04 |
| stmt execute | 1,077 | 0.7 | 0.04 |
| insert | 886 | 0.6 | 0.03 |
| show table status | 504 | 0.3 | 0.02 |
| show slave status | 500 | 0.3 | 0.02 |
| show master status | 480 | 0.3 | 0.02 |
| show status | 150 | 0.1 | 0.01 |
| show processlist | 19 | <0.1 | <0.01 |
| show engine status | 12 | <0.1 | <0.01 |
| flush | 10 | <0.1 | <0.01 |