| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 47,827 | 422.2 | 77.69 |
| show tables | 3,089 | 27.3 | 5.02 |
| show fields | 2,967 | 26.2 | 4.82 |
| change db | 2,340 | 20.7 | 3.80 |
| show keys | 1,778 | 15.7 | 2.89 |
| set option | 1,674 | 14.8 | 2.72 |
| show variables | 384 | 3.4 | 0.62 |
| show grants | 363 | 3.2 | 0.59 |
| show create table | 326 | 2.9 | 0.53 |
| replace | 306 | 2.7 | 0.50 |
| show warnings | 129 | 1.1 | 0.21 |
| show storage engines | 92 | 0.8 | 0.15 |
| show binlogs | 78 | 0.7 | 0.13 |
| stmt prepare | 67 | 0.6 | 0.11 |
| stmt close | 37 | 0.3 | 0.06 |
| stmt execute | 37 | 0.3 | 0.06 |
| show slave status | 28 | 0.2 | 0.05 |
| show master status | 25 | 0.2 | 0.04 |
| show status | 8 | 0.1 | 0.01 |
| show table status | 5 | <0.1 | 0.01 |
| update | 4 | <0.1 | 0.01 |