控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 1,718 k | 7,863.7 | 81.90 |
| show tables | 84,705 | 387.7 | 4.04 |
| show fields | 78,619 | 359.8 | 3.75 |
| change db | 59,025 | 270.1 | 2.81 |
| set option | 45,900 | 210.1 | 2.19 |
| show keys | 37,324 | 170.8 | 1.78 |
| show variables | 14,145 | 64.7 | 0.67 |
| replace | 12,753 | 58.4 | 0.61 |
| show create table | 9,449 | 43.2 | 0.45 |
| stmt prepare | 9,194 | 42.1 | 0.44 |
| stmt execute | 9,174 | 42 | 0.44 |
| stmt close | 9,168 | 42 | 0.44 |
| show warnings | 5,836 | 26.7 | 0.28 |
| show storage engines | 1,911 | 8.7 | 0.09 |
| show grants | 775 | 3.5 | 0.04 |
| update | 342 | 1.6 | 0.02 |
| show table status | 263 | 1.2 | 0.01 |
| show binlogs | 241 | 1.1 | 0.01 |
| show slave status | 240 | 1.1 | 0.01 |
| show master status | 232 | 1.1 | 0.01 |
| insert | 119 | 0.5 | 0.01 |
| begin | 100 | 0.5 | <0.01 |
| commit | 94 | 0.4 | <0.01 |
| show status | 24 | 0.1 | <0.01 |
| alter table | 6 | <0.1 | <0.01 |
| rollback | 6 | <0.1 | <0.01 |
| create table | 4 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| delete | 1 | <0.1 | <0.01 |
| rename table | 1 | <0.1 | <0.01 |