| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 697 k | 1,648.4 | 79.01 |
| show tables | 48,325 | 114.2 | 5.48 |
| show fields | 41,438 | 97.9 | 4.70 |
| change db | 33,468 | 79.1 | 3.79 |
| set option | 25,945 | 61.3 | 2.94 |
| show keys | 14,812 | 35 | 1.68 |
| show variables | 6,316 | 14.9 | 0.72 |
| replace | 5,347 | 12.6 | 0.61 |
| show create table | 4,001 | 9.5 | 0.45 |
| show warnings | 2,262 | 5.3 | 0.26 |
| show storage engines | 919 | 2.2 | 0.10 |
| show grants | 498 | 1.2 | 0.06 |
| show binlogs | 350 | 0.8 | 0.04 |
| stmt prepare | 297 | 0.7 | 0.03 |
| update | 270 | 0.6 | 0.03 |
| insert | 230 | 0.5 | 0.03 |
| stmt close | 217 | 0.5 | 0.02 |
| stmt execute | 217 | 0.5 | 0.02 |
| show table status | 113 | 0.3 | 0.01 |
| show slave status | 94 | 0.2 | 0.01 |
| show master status | 91 | 0.2 | 0.01 |
| show status | 18 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |