控制台
| 说明 | 查询数量 | ø 每小时 | % |
|---|---|---|---|
| select | 12,580 k | 4,384.5 | 78.00 |
| show tables | 836 k | 291.5 | 5.19 |
| change db | 662 k | 230.6 | 4.10 |
| show fields | 642 k | 223.8 | 3.98 |
| show variables | 521 k | 181.7 | 3.23 |
| set option | 495 k | 172.4 | 3.07 |
| show warnings | 150 k | 52.2 | 0.93 |
| show keys | 112 k | 39.2 | 0.70 |
| show grants | 54,815 | 19.1 | 0.34 |
| show create table | 46,761 | 16.3 | 0.29 |
| replace | 17,415 | 6.1 | 0.11 |
| show binlogs | 3,749 | 1.3 | 0.02 |
| stmt prepare | 1,743 | 0.6 | 0.01 |
| show storage engines | 1,515 | 0.5 | 0.01 |
| stmt close | 1,033 | 0.4 | 0.01 |
| stmt execute | 1,033 | 0.4 | 0.01 |
| show slave status | 781 | 0.3 | <0.01 |
| show master status | 745 | 0.3 | <0.01 |
| show table status | 439 | 0.2 | <0.01 |
| show status | 179 | 0.1 | <0.01 |
| update | 38 | <0.1 | <0.01 |
| show processlist | 22 | <0.1 | <0.01 |
| flush | 16 | <0.1 | <0.01 |
| show engine status | 10 | <0.1 | <0.01 |
| alter table | 6 | <0.1 | <0.01 |
| create db | 6 | <0.1 | <0.01 |
| create table | 6 | <0.1 | <0.01 |
| delete | 6 | <0.1 | <0.01 |
| drop db | 6 | <0.1 | <0.01 |
| insert | 6 | <0.1 | <0.01 |
| show databases | 3 | <0.1 | <0.01 |