说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 12,630 k | 4,379.6 | 78.00 |
show tables | 840 k | 291.2 | 5.19 |
change db | 664 k | 230.3 | 4.10 |
show fields | 645 k | 223.6 | 3.98 |
show variables | 523 k | 181.3 | 3.23 |
set option | 497 k | 172.2 | 3.07 |
show warnings | 150 k | 52.1 | 0.93 |
show keys | 113 k | 39.3 | 0.70 |
show grants | 55,119 | 19.1 | 0.34 |
show create table | 46,921 | 16.3 | 0.29 |
replace | 17,475 | 6.1 | 0.11 |
show binlogs | 3,874 | 1.3 | 0.02 |
stmt prepare | 1,820 | 0.6 | 0.01 |
show storage engines | 1,547 | 0.5 | 0.01 |
stmt close | 1,075 | 0.4 | 0.01 |
stmt execute | 1,075 | 0.4 | 0.01 |
show slave status | 805 | 0.3 | <0.01 |
show master status | 769 | 0.3 | <0.01 |
show table status | 451 | 0.2 | <0.01 |
show status | 194 | 0.1 | <0.01 |
update | 38 | <0.1 | <0.01 |
show processlist | 24 | <0.1 | <0.01 |
flush | 16 | <0.1 | <0.01 |
show engine status | 12 | <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 |