| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 731 k | 1,875.9 | 78.22 |
| show tables | 53,845 | 138.1 | 5.76 |
| show fields | 45,384 | 116.4 | 4.85 |
| change db | 36,315 | 93.1 | 3.88 |
| set option | 26,796 | 68.7 | 2.87 |
| show keys | 16,142 | 41.4 | 1.73 |
| replace | 6,616 | 17 | 0.71 |
| show variables | 4,792 | 12.3 | 0.51 |
| show create table | 4,782 | 12.3 | 0.51 |
| show grants | 2,960 | 7.6 | 0.32 |
| show storage engines | 1,579 | 4 | 0.17 |
| show warnings | 1,399 | 3.6 | 0.15 |
| stmt prepare | 722 | 1.9 | 0.08 |
| stmt close | 487 | 1.2 | 0.05 |
| stmt execute | 487 | 1.2 | 0.05 |
| insert | 324 | 0.8 | 0.03 |
| show binlogs | 277 | 0.7 | 0.03 |
| show slave status | 230 | 0.6 | 0.02 |
| show master status | 220 | 0.6 | 0.02 |
| show table status | 204 | 0.5 | 0.02 |
| show status | 52 | 0.1 | 0.01 |
| show processlist | 7 | <0.1 | <0.01 |
| flush | 5 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |