| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 167 k | 936.4 | 77.60 |
| show tables | 10,985 | 61.5 | 5.09 |
| show fields | 10,422 | 58.3 | 4.83 |
| change db | 7,996 | 44.7 | 3.71 |
| set option | 5,778 | 32.3 | 2.68 |
| show keys | 5,643 | 31.6 | 2.62 |
| show grants | 1,651 | 9.2 | 0.77 |
| show variables | 1,560 | 8.7 | 0.72 |
| replace | 1,401 | 7.8 | 0.65 |
| show create table | 1,134 | 6.3 | 0.53 |
| show warnings | 533 | 3 | 0.25 |
| show storage engines | 383 | 2.1 | 0.18 |
| stmt prepare | 223 | 1.2 | 0.10 |
| show binlogs | 168 | 0.9 | 0.08 |
| stmt close | 133 | 0.7 | 0.06 |
| stmt execute | 133 | 0.7 | 0.06 |
| show slave status | 60 | 0.3 | 0.03 |
| show master status | 57 | 0.3 | 0.03 |
| show table status | 26 | 0.1 | 0.01 |
| show status | 17 | 0.1 | 0.01 |
| update | 4 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |