说明 | 查询数量 | ø 每小时 | % |
---|---|---|---|
select | 3,654 k | 2,496.6 | 93.33 |
insert | 55,562 | 38 | 1.42 |
set option | 52,515 | 35.9 | 1.34 |
show tables | 35,334 | 24.1 | 0.90 |
show fields | 27,218 | 18.6 | 0.70 |
change db | 25,612 | 17.5 | 0.65 |
update | 24,115 | 16.5 | 0.62 |
insert select | 15,814 | 10.8 | 0.40 |
delete | 13,845 | 9.5 | 0.35 |
show keys | 4,505 | 3.1 | 0.12 |
show variables | 1,714 | 1.2 | 0.04 |
replace | 1,690 | 1.2 | 0.04 |
show create table | 1,076 | 0.7 | 0.03 |
show warnings | 377 | 0.3 | 0.01 |
show grants | 330 | 0.2 | 0.01 |
show storage engines | 318 | 0.2 | 0.01 |
stmt prepare | 195 | 0.1 | <0.01 |
show binlogs | 137 | 0.1 | <0.01 |
delete multi | 116 | 0.1 | <0.01 |
stmt close | 105 | 0.1 | <0.01 |
stmt execute | 105 | 0.1 | <0.01 |
show table status | 97 | 0.1 | <0.01 |
alter table | 92 | 0.1 | <0.01 |
show slave status | 74 | 0.1 | <0.01 |
show master status | 71 | <0.1 | <0.01 |
show status | 16 | <0.1 | <0.01 |
truncate | 7 | <0.1 | <0.01 |
show databases | 3 | <0.1 | <0.01 |
flush | 2 | <0.1 | <0.01 |
show processlist | 2 | <0.1 | <0.01 |
show engine status | 1 | <0.1 | <0.01 |