Các câu lệnh | # | ø per hour | % |
---|---|---|---|
select | 60.890 k | 92,6 k | 78,52 |
show fields | 3.977 k | 6.046,9 | 5,13 |
show tables | 3.335 k | 5.070,9 | 4,30 |
change db | 2.660 k | 4.043,5 | 3,43 |
set option | 2.014 k | 3.061,3 | 2,60 |
show keys | 1.339 k | 2.036,2 | 1,73 |
show variables | 1.317 k | 2.002,9 | 1,70 |
show grants | 659 k | 1.002,4 | <0.01 |
show create table | 659 k | 1.001,9 | <0.01 |
show warnings | 658 k | 1.001 | <0.01 |
update | 22.518 | 34,2 | <0.01 |
show binlogs | 6.577 | 10 | <0.01 |
begin | 1.588 | 2,4 | <0.01 |
commit | 1.568 | 2,4 | <0.01 |
replace | 1.346 | 2 | <0.01 |
insert | 923 | 1,4 | <0.01 |
stmt execute | 645 | 1 | <0.01 |
stmt prepare | 645 | 1 | <0.01 |
create table | 584 | 0,9 | <0.01 |
stmt close | 308 | 0,5 | <0.01 |
show storage engines | 275 | 0,4 | <0.01 |
delete | 250 | 0,4 | <0.01 |
show slave status | 145 | 0,2 | <0.01 |
show master status | 132 | 0,2 | <0.01 |
show table status | 91 | 0,1 | <0.01 |
show status | 42 | 0,1 | <0.01 |
rollback | 20 | <0,1 | <0.01 |
flush | 5 | <0,1 | <0.01 |
show processlist | 5 | <0,1 | <0.01 |
show engine status | 2 | <0,1 | <0.01 |