说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 50,279 k | 64.6 k | 79.64 |
show fields | 2,702 k | 3,472.5 | 4.28 |
show tables | 2,258 k | 2,901.8 | 3.58 |
show keys | 2,244 k | 2,883.6 | 3.55 |
change db | 1,805 k | 2,319.2 | 2.86 |
set option | 1,354 k | 1,740.3 | 2.15 |
show variables | 898 k | 1,153.9 | 1.42 |
show grants | 450 k | 578.1 | 0.71 |
show create table | 449 k | 577.2 | 0.71 |
show warnings | 449 k | 576.6 | 0.71 |
replace | 168 k | 215.6 | 0.27 |
stmt close | 24,986 | 32.1 | 0.04 |
stmt execute | 24,986 | 32.1 | 0.04 |
stmt prepare | 24,986 | 32.1 | 0.04 |
show binlogs | 1,550 | 2 | <0.01 |
show storage engines | 198 | 0.3 | <0.01 |
insert | 190 | 0.2 | <0.01 |
delete | 137 | 0.2 | <0.01 |
show slave status | 106 | 0.1 | <0.01 |
show master status | 98 | 0.1 | <0.01 |
show table status | 57 | 0.1 | <0.01 |
show status | 39 | 0.1 | <0.01 |
update | 25 | <0.1 | <0.01 |
show processlist | 6 | <0.1 | <0.01 |
show databases | 1 | <0.1 | <0.01 |