Statements | # | ø per hour | % |
---|---|---|---|
select | 5,781 k | 3,150.6 | 80.63 |
show tables | 376 k | 205 | 5.25 |
show fields | 303 k | 165.3 | 4.23 |
change db | 261 k | 142.4 | 3.64 |
set option | 170 k | 92.5 | 2.37 |
show keys | 83,339 | 45.4 | 1.16 |
show variables | 62,364 | 34 | 0.87 |
show create table | 25,917 | 14.1 | 0.36 |
show grants | 21,645 | 11.8 | 0.30 |
replace | 20,535 | 11.2 | 0.29 |
show warnings | 19,237 | 10.5 | 0.27 |
show binlogs | 18,888 | 10.3 | 0.26 |
update | 11,661 | 6.4 | 0.16 |
show storage engines | 3,487 | 1.9 | 0.05 |
stmt prepare | 2,411 | 1.3 | 0.03 |
insert | 1,726 | 0.9 | 0.02 |
show table status | 1,522 | 0.8 | 0.02 |
stmt close | 1,426 | 0.8 | 0.02 |
stmt execute | 1,426 | 0.8 | 0.02 |
show slave status | 917 | 0.5 | 0.01 |
show master status | 893 | 0.5 | 0.01 |
delete | 882 | 0.5 | 0.01 |
show status | 142 | 0.1 | <0.01 |
alter table | 72 | <0.1 | <0.01 |
show profile | 66 | <0.1 | <0.01 |
flush | 12 | <0.1 | <0.01 |
create table | 11 | <0.1 | <0.01 |
truncate | 11 | <0.1 | <0.01 |
show processlist | 10 | <0.1 | <0.01 |
show engine status | 7 | <0.1 | <0.01 |
show function status | 6 | <0.1 | <0.01 |
show procedure status | 6 | <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 |