| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 3,425 k | 96.9 k | 79.92 |
| show fields | 214 k | 6,056 | 4.99 |
| show tables | 180 k | 5,081.5 | 4.19 |
| change db | 143 k | 4,052.9 | 3.34 |
| set option | 108 k | 3,045.9 | 2.51 |
| show variables | 70,669 | 2,000 | 1.65 |
| show keys | 36,136 | 1,022.7 | 0.84 |
| show grants | 35,384 | 1,001.4 | 0.83 |
| show create table | 35,374 | 1,001.1 | 0.83 |
| show warnings | 35,293 | 998.8 | 0.82 |
| replace | 2,886 | 81.7 | 0.07 |
| show binlogs | 114 | 3.2 | <0.01 |
| stmt prepare | 66 | 1.9 | <0.01 |
| update | 65 | 1.8 | <0.01 |
| show storage engines | 37 | 1 | <0.01 |
| stmt close | 36 | 1 | <0.01 |
| stmt execute | 36 | 1 | <0.01 |
| show slave status | 31 | 0.9 | <0.01 |
| show master status | 29 | 0.8 | <0.01 |
| show status | 14 | 0.4 | <0.01 |
| show table status | 13 | 0.4 | <0.01 |
| show processlist | 2 | 0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |