Statements | # | ø per hour | % |
---|---|---|---|
select | 5,657 k | 3,143 | 80.68 |
show tables | 366 k | 203.6 | 5.23 |
show fields | 295 k | 164.1 | 4.21 |
change db | 255 k | 141.7 | 3.64 |
set option | 167 k | 92.6 | 2.38 |
show keys | 80,319 | 44.6 | 1.15 |
show variables | 61,167 | 34 | 0.87 |
show create table | 25,181 | 14 | 0.36 |
show grants | 21,214 | 11.8 | 0.30 |
replace | 19,251 | 10.7 | 0.27 |
show binlogs | 18,828 | 10.5 | 0.27 |
show warnings | 18,828 | 10.5 | 0.27 |
update | 11,637 | 6.5 | 0.17 |
show storage engines | 3,381 | 1.9 | 0.05 |
stmt prepare | 2,344 | 1.3 | 0.03 |
insert | 1,726 | 1 | 0.02 |
show table status | 1,466 | 0.8 | 0.02 |
stmt close | 1,389 | 0.8 | 0.02 |
stmt execute | 1,389 | 0.8 | 0.02 |
show slave status | 906 | 0.5 | 0.01 |
show master status | 883 | 0.5 | 0.01 |
delete | 882 | 0.5 | 0.01 |
show status | 136 | 0.1 | <0.01 |
alter table | 72 | <0.1 | <0.01 |
show profile | 66 | <0.1 | <0.01 |
create table | 11 | <0.1 | <0.01 |
flush | 11 | <0.1 | <0.01 |
truncate | 11 | <0.1 | <0.01 |
show processlist | 10 | <0.1 | <0.01 |
show function status | 6 | <0.1 | <0.01 |
show procedure status | 6 | <0.1 | <0.01 |
show engine status | 4 | <0.1 | <0.01 |
show databases | 2 | <0.1 | <0.01 |
begin | 1 | <0.1 | <0.01 |
commit | 1 | <0.1 | <0.01 |
drop table | 1 | <0.1 | <0.01 |