| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,906 k | 1,289.8 | 78.85 |
| show tables | 140 k | 94.7 | 5.79 |
| show fields | 112 k | 75.9 | 4.64 |
| change db | 92,841 | 62.8 | 3.84 |
| set option | 71,016 | 48.1 | 2.94 |
| show keys | 35,159 | 23.8 | 1.45 |
| replace | 15,348 | 10.4 | 0.64 |
| show variables | 11,498 | 7.8 | 0.48 |
| show create table | 10,346 | 7 | 0.43 |
| show grants | 9,285 | 6.3 | 0.38 |
| show storage engines | 3,381 | 2.3 | 0.14 |
| show warnings | 3,211 | 2.2 | 0.13 |
| stmt prepare | 1,402 | 0.9 | 0.06 |
| show binlogs | 1,379 | 0.9 | 0.06 |
| stmt close | 987 | 0.7 | 0.04 |
| stmt execute | 987 | 0.7 | 0.04 |
| insert | 886 | 0.6 | 0.04 |
| show slave status | 460 | 0.3 | 0.02 |
| show table status | 455 | 0.3 | 0.02 |
| show master status | 444 | 0.3 | 0.02 |
| show status | 127 | 0.1 | 0.01 |
| show processlist | 16 | <0.1 | <0.01 |
| show engine status | 11 | <0.1 | <0.01 |
| flush | 8 | <0.1 | <0.01 |