| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 20,939 k | 4,557.8 | 77.28 |
| show fields | 1,448 k | 315.3 | 5.35 |
| show tables | 1,191 k | 259.3 | 4.40 |
| show keys | 918 k | 199.8 | 3.39 |
| change db | 913 k | 198.8 | 3.37 |
| set option | 685 k | 149.1 | 2.53 |
| show variables | 368 k | 80.2 | 1.36 |
| show create table | 192 k | 41.7 | 0.71 |
| show warnings | 176 k | 38.4 | 0.65 |
| show grants | 166 k | 36.1 | 0.61 |
| replace | 65,354 | 14.2 | 0.24 |
| show storage engines | 8,964 | 2 | 0.03 |
| show binlogs | 5,797 | 1.3 | 0.02 |
| stmt close | 3,965 | 0.9 | 0.01 |
| stmt execute | 3,965 | 0.9 | 0.01 |
| stmt prepare | 3,965 | 0.9 | 0.01 |
| show slave status | 1,688 | 0.4 | 0.01 |
| show master status | 1,479 | 0.3 | 0.01 |
| show table status | 1,168 | 0.3 | <0.01 |
| update | 1,039 | 0.2 | <0.01 |
| show status | 318 | 0.1 | <0.01 |
| show processlist | 30 | <0.1 | <0.01 |
| flush | 28 | <0.1 | <0.01 |
| show engine status | 23 | <0.1 | <0.01 |
| insert | 1 | <0.1 | <0.01 |