说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 12,300 k | 4,369.5 | 78.01 |
show tables | 816 k | 289.8 | 5.17 |
change db | 646 k | 229.5 | 4.10 |
show fields | 628 k | 223.3 | 3.99 |
show variables | 509 k | 180.7 | 3.23 |
set option | 483 k | 171.6 | 3.06 |
show warnings | 147 k | 52.2 | 0.93 |
show keys | 111 k | 39.3 | 0.70 |
show grants | 53,938 | 19.2 | 0.34 |
show create table | 46,507 | 16.5 | 0.29 |
replace | 17,365 | 6.2 | 0.11 |
show binlogs | 3,347 | 1.2 | 0.02 |
stmt prepare | 1,501 | 0.5 | 0.01 |
show storage engines | 1,452 | 0.5 | 0.01 |
stmt close | 901 | 0.3 | 0.01 |
stmt execute | 901 | 0.3 | 0.01 |
show slave status | 653 | 0.2 | <0.01 |
show master status | 629 | 0.2 | <0.01 |
show table status | 379 | 0.1 | <0.01 |
show status | 122 | <0.1 | <0.01 |
update | 38 | <0.1 | <0.01 |
show processlist | 16 | <0.1 | <0.01 |
flush | 10 | <0.1 | <0.01 |
show engine status | 7 | <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 |