说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 1,200 k | 16.3 k | 64.26 |
set option | 166 k | 2,247.9 | 8.88 |
show fields | 133 k | 1,800.2 | 7.11 |
show keys | 104 k | 1,414.3 | 5.59 |
change db | 54,253 | 735.3 | 2.91 |
replace | 49,872 | 676 | 2.67 |
show variables | 45,244 | 613.2 | 2.42 |
show tables | 39,325 | 533 | 2.11 |
show create table | 37,029 | 501.9 | 1.98 |
show warnings | 17,356 | 235.2 | 0.93 |
show storage engines | 10,766 | 145.9 | 0.58 |
show table status | 4,741 | 64.3 | 0.25 |
stmt close | 1,557 | 21.1 | 0.08 |
stmt execute | 1,557 | 21.1 | 0.08 |
stmt prepare | 1,557 | 21.1 | 0.08 |
delete | 721 | 9.8 | 0.04 |
show slave status | 150 | 2 | 0.01 |
show master status | 146 | 2 | 0.01 |
show grants | 37 | 0.5 | <0.01 |
show binlogs | 28 | 0.4 | <0.01 |
show status | 26 | 0.4 | <0.01 |
show processlist | 3 | <0.1 | <0.01 |
show engine status | 2 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |