Các câu lệnh | # | ø per hour | % |
---|---|---|---|
select | 60.172 k | 92,1 k | 78,48 |
show fields | 3.943 k | 6.033,9 | 5,14 |
show tables | 3.306 k | 5.059,5 | 4,31 |
change db | 2.637 k | 4.034,5 | 3,44 |
set option | 1.996 k | 3.055 | 2,60 |
show keys | 1.312 k | 2.007,2 | 1,71 |
show variables | 1.307 k | 2.000,1 | 1,70 |
show grants | 654 k | 1.000,9 | <0.01 |
show create table | 654 k | 1.000,1 | <0.01 |
show warnings | 653 k | 999,7 | <0.01 |
update | 22.458 | 34,4 | <0.01 |
show binlogs | 6.470 | 9,9 | <0.01 |
begin | 1.583 | 2,4 | <0.01 |
commit | 1.563 | 2,4 | <0.01 |
insert | 923 | 1,4 | <0.01 |
replace | 782 | 1,2 | <0.01 |
create table | 559 | 0,9 | <0.01 |
stmt execute | 521 | 0,8 | <0.01 |
stmt prepare | 521 | 0,8 | <0.01 |
delete | 250 | 0,4 | <0.01 |
stmt close | 191 | 0,3 | <0.01 |
show storage engines | 133 | 0,2 | <0.01 |
show slave status | 102 | 0,2 | <0.01 |
show master status | 92 | 0,1 | <0.01 |
show table status | 58 | 0,1 | <0.01 |
rollback | 20 | <0,1 | <0.01 |
show status | 16 | <0,1 | <0.01 |
flush | 2 | <0,1 | <0.01 |
show processlist | 1 | <0,1 | <0.01 |