| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 2,922 k | 1,374.2 | 77.62 |
| show tables | 197 k | 92.8 | 5.24 |
| show fields | 186 k | 87.7 | 4.95 |
| change db | 140 k | 65.8 | 3.72 |
| set option | 106 k | 49.9 | 2.82 |
| show keys | 97,394 | 45.8 | 2.59 |
| show variables | 34,265 | 16.1 | 0.91 |
| replace | 28,160 | 13.2 | 0.75 |
| show create table | 21,122 | 9.9 | 0.56 |
| show warnings | 14,256 | 6.7 | 0.38 |
| show grants | 7,729 | 3.6 | 0.21 |
| show storage engines | 3,513 | 1.7 | 0.09 |
| show binlogs | 1,390 | 0.7 | 0.04 |
| stmt close | 1,000 | 0.5 | 0.03 |
| stmt execute | 1,000 | 0.5 | 0.03 |
| stmt prepare | 1,000 | 0.5 | 0.03 |
| update | 573 | 0.3 | 0.02 |
| show slave status | 524 | 0.2 | 0.01 |
| show master status | 501 | 0.2 | 0.01 |
| show table status | 349 | 0.2 | 0.01 |
| show status | 109 | 0.1 | <0.01 |
| show processlist | 14 | <0.1 | <0.01 |
| show engine status | 10 | <0.1 | <0.01 |
| flush | 8 | <0.1 | <0.01 |
| insert | 1 | <0.1 | <0.01 |