| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 938 k | 1,352.9 | 77.47 |
| show tables | 62,305 | 89.9 | 5.15 |
| show fields | 59,052 | 85.2 | 4.88 |
| change db | 43,885 | 63.3 | 3.63 |
| show keys | 35,825 | 51.7 | 2.96 |
| set option | 32,328 | 46.6 | 2.67 |
| show grants | 8,990 | 13 | 0.74 |
| show create table | 8,417 | 12.1 | 0.70 |
| show variables | 6,863 | 9.9 | 0.57 |
| replace | 6,298 | 9.1 | 0.52 |
| show binlogs | 2,493 | 3.6 | 0.21 |
| show warnings | 1,447 | 2.1 | 0.12 |
| show storage engines | 1,309 | 1.9 | 0.11 |
| stmt prepare | 1,251 | 1.8 | 0.10 |
| stmt close | 736 | 1.1 | 0.06 |
| stmt execute | 736 | 1.1 | 0.06 |
| show slave status | 318 | 0.5 | 0.03 |
| show master status | 308 | 0.4 | 0.03 |
| show table status | 136 | 0.2 | 0.01 |
| show status | 46 | 0.1 | <0.01 |
| update | 42 | 0.1 | <0.01 |
| show processlist | 6 | <0.1 | <0.01 |
| show engine status | 4 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |