| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 873 k | 1,265.8 | 77.60 |
| show tables | 57,793 | 83.8 | 5.14 |
| show fields | 54,240 | 78.6 | 4.82 |
| change db | 40,260 | 58.4 | 3.58 |
| show keys | 32,641 | 47.3 | 2.90 |
| set option | 29,985 | 43.5 | 2.67 |
| show grants | 8,676 | 12.6 | 0.77 |
| show create table | 7,943 | 11.5 | 0.71 |
| show variables | 6,415 | 9.3 | 0.57 |
| replace | 5,855 | 8.5 | 0.52 |
| show binlogs | 2,379 | 3.4 | 0.21 |
| show warnings | 1,407 | 2 | 0.13 |
| stmt prepare | 1,152 | 1.7 | 0.10 |
| show storage engines | 1,108 | 1.6 | 0.10 |
| stmt close | 682 | 1 | 0.06 |
| stmt execute | 682 | 1 | 0.06 |
| show slave status | 296 | 0.4 | 0.03 |
| show master status | 288 | 0.4 | 0.03 |
| show table status | 111 | 0.2 | 0.01 |
| update | 42 | 0.1 | <0.01 |
| show status | 29 | <0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |