| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 933 k | 2,045.7 | 78.69 |
| show tables | 67,360 | 147.7 | 5.68 |
| show fields | 55,283 | 121.2 | 4.66 |
| change db | 45,715 | 100.2 | 3.86 |
| set option | 34,044 | 74.6 | 2.87 |
| show keys | 17,244 | 37.8 | 1.45 |
| replace | 8,503 | 18.6 | 0.72 |
| show variables | 6,409 | 14.1 | 0.54 |
| show grants | 6,059 | 13.3 | 0.51 |
| show create table | 5,392 | 11.8 | 0.45 |
| show storage engines | 1,833 | 4 | 0.15 |
| show warnings | 1,713 | 3.8 | 0.14 |
| stmt prepare | 828 | 1.8 | 0.07 |
| stmt close | 603 | 1.3 | 0.05 |
| stmt execute | 603 | 1.3 | 0.05 |
| show binlogs | 414 | 0.9 | 0.03 |
| show table status | 225 | 0.5 | 0.02 |
| show slave status | 215 | 0.5 | 0.02 |
| show master status | 207 | 0.5 | 0.02 |
| insert | 46 | 0.1 | <0.01 |
| show status | 38 | 0.1 | <0.01 |
| show processlist | 6 | <0.1 | <0.01 |
| show engine status | 5 | <0.1 | <0.01 |
| flush | 4 | <0.1 | <0.01 |