| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 116 k | 966.5 | 78.76 |
| show tables | 8,143 | 67.6 | 5.51 |
| show fields | 6,745 | 56 | 4.57 |
| change db | 6,376 | 53 | 4.32 |
| set option | 4,404 | 36.6 | 2.98 |
| show keys | 2,481 | 20.6 | 1.68 |
| show variables | 1,127 | 9.4 | 0.76 |
| replace | 529 | 4.4 | 0.36 |
| show grants | 427 | 3.5 | 0.29 |
| show create table | 403 | 3.3 | 0.27 |
| show binlogs | 243 | 2 | 0.16 |
| show storage engines | 171 | 1.4 | 0.12 |
| show warnings | 79 | 0.7 | 0.05 |
| show slave status | 43 | 0.4 | 0.03 |
| show master status | 40 | 0.3 | 0.03 |
| stmt close | 36 | 0.3 | 0.02 |
| stmt execute | 36 | 0.3 | 0.02 |
| stmt prepare | 36 | 0.3 | 0.02 |
| show table status | 34 | 0.3 | 0.02 |
| show status | 14 | 0.1 | 0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |