Các câu lệnh | # | ø per hour | % |
---|---|---|---|
select | 60.021 k | 92 k | 78,48 |
show fields | 3.934 k | 6.030,7 | 5,14 |
show tables | 3.298 k | 5.056,6 | 4,31 |
change db | 2.630 k | 4.032,3 | 3,44 |
set option | 1.992 k | 3.053,4 | 2,60 |
show keys | 1.304 k | 1.999,5 | 1,71 |
show variables | 1.304 k | 1.999,2 | 1,71 |
show grants | 653 k | 1.000,3 | <0.01 |
show create table | 652 k | 999,6 | <0.01 |
show warnings | 652 k | 999,3 | <0.01 |
update | 22.458 | 34,4 | <0.01 |
show binlogs | 6.425 | 9,8 | <0.01 |
begin | 1.583 | 2,4 | <0.01 |
commit | 1.563 | 2,4 | <0.01 |
insert | 923 | 1,4 | <0.01 |
replace | 767 | 1,2 | <0.01 |
create table | 559 | 0,9 | <0.01 |
stmt execute | 493 | 0,8 | <0.01 |
stmt prepare | 493 | 0,8 | <0.01 |
delete | 250 | 0,4 | <0.01 |
stmt close | 165 | 0,3 | <0.01 |
show storage engines | 123 | 0,2 | <0.01 |
show slave status | 84 | 0,1 | <0.01 |
show master status | 76 | 0,1 | <0.01 |
show table status | 47 | 0,1 | <0.01 |
rollback | 20 | <0,1 | <0.01 |
show status | 9 | <0,1 | <0.01 |
flush | 1 | <0,1 | <0.01 |