| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 13,458 k | 25.7 k | 78.84 |
| show fields | 949 k | 1,812.7 | 5.56 |
| show tables | 717 k | 1,369.5 | 4.20 |
| change db | 561 k | 1,072.2 | 3.29 |
| set option | 428 k | 817.2 | 2.51 |
| show variables | 261 k | 497.6 | 1.53 |
| show keys | 252 k | 481.5 | 1.48 |
| show create table | 131 k | 250 | 0.77 |
| show warnings | 130 k | 247.4 | 0.76 |
| show grants | 128 k | 243.6 | 0.75 |
| replace | 49,786 | 95.1 | 0.29 |
| show binlogs | 1,768 | 3.4 | 0.01 |
| update | 1,559 | 3 | 0.01 |
| show storage engines | 780 | 1.5 | <0.01 |
| insert | 366 | 0.7 | <0.01 |
| stmt prepare | 101 | 0.2 | <0.01 |
| show slave status | 92 | 0.2 | <0.01 |
| show master status | 86 | 0.2 | <0.01 |
| stmt close | 66 | 0.1 | <0.01 |
| stmt execute | 66 | 0.1 | <0.01 |
| show table status | 54 | 0.1 | <0.01 |
| show status | 16 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |