| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,780 k | 8,095.6 | 81.78 |
| show tables | 88,972 | 404.6 | 4.09 |
| show fields | 82,399 | 374.7 | 3.79 |
| change db | 62,059 | 282.2 | 2.85 |
| set option | 48,060 | 218.5 | 2.21 |
| show keys | 39,133 | 178 | 1.80 |
| show variables | 14,630 | 66.5 | 0.67 |
| replace | 13,114 | 59.6 | 0.60 |
| show create table | 9,767 | 44.4 | 0.45 |
| stmt prepare | 9,259 | 42.1 | 0.43 |
| stmt execute | 9,239 | 42 | 0.42 |
| stmt close | 9,233 | 42 | 0.42 |
| show warnings | 5,932 | 27 | 0.27 |
| show storage engines | 1,988 | 9 | 0.09 |
| show grants | 1,046 | 4.8 | 0.05 |
| update | 342 | 1.6 | 0.02 |
| show binlogs | 331 | 1.5 | 0.02 |
| show table status | 296 | 1.3 | 0.01 |
| show slave status | 257 | 1.2 | 0.01 |
| show master status | 248 | 1.1 | 0.01 |
| insert | 119 | 0.5 | 0.01 |
| begin | 100 | 0.5 | <0.01 |
| commit | 94 | 0.4 | <0.01 |
| show status | 32 | 0.1 | <0.01 |
| alter table | 6 | <0.1 | <0.01 |
| rollback | 6 | <0.1 | <0.01 |
| flush | 5 | <0.1 | <0.01 |
| create table | 4 | <0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| delete | 1 | <0.1 | <0.01 |
| rename table | 1 | <0.1 | <0.01 |