Statements | # | ø per hour | % |
---|---|---|---|
select | 277 k | 1,613.3 | 56.97 |
update | 74,848 | 435.3 | 15.37 |
set option | 72,853 | 423.7 | 14.96 |
show tables | 17,328 | 100.8 | 3.56 |
insert | 16,473 | 95.8 | 3.38 |
show fields | 8,345 | 48.5 | 1.71 |
show keys | 6,257 | 36.4 | 1.28 |
change db | 4,213 | 24.5 | 0.87 |
show variables | 3,094 | 18 | 0.64 |
show create table | 1,878 | 10.9 | 0.39 |
show warnings | 1,225 | 7.1 | 0.25 |
show grants | 997 | 5.8 | 0.20 |
delete | 701 | 4.1 | 0.14 |
show table status | 328 | 1.9 | 0.07 |
show slave status | 282 | 1.6 | 0.06 |
show master status | 280 | 1.6 | 0.06 |
show binlogs | 209 | 1.2 | 0.04 |
show storage engines | 73 | 0.4 | 0.01 |
create table | 31 | 0.2 | 0.01 |
alter table | 30 | 0.2 | 0.01 |
show function status | 19 | 0.1 | <0.01 |
show procedure status | 19 | 0.1 | <0.01 |
show status | 9 | 0.1 | <0.01 |
update multi | 5 | <0.1 | <0.01 |
insert select | 3 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |
begin | 1 | <0.1 | <0.01 |
show databases | 1 | <0.1 | <0.01 |
empty query | 1 | <0.1 | <0.01 |
drop db | 1 | <0.1 | <0.01 |
create db | 1 | <0.1 | <0.01 |
commit | 1 | <0.1 | <0.01 |