Statements | # | ø per hour | % |
---|---|---|---|
select | 281 k | 1,611.7 | 56.69 |
update | 75,472 | 433 | 15.23 |
set option | 74,106 | 425.2 | 14.96 |
show tables | 18,089 | 103.8 | 3.65 |
insert | 16,476 | 94.5 | 3.33 |
show fields | 9,174 | 52.6 | 1.85 |
show keys | 7,044 | 40.4 | 1.42 |
change db | 4,524 | 26 | 0.91 |
show variables | 3,177 | 18.2 | 0.64 |
show create table | 2,067 | 11.9 | 0.42 |
show warnings | 1,236 | 7.1 | 0.25 |
show grants | 1,155 | 6.6 | 0.23 |
delete | 702 | 4 | 0.14 |
show table status | 329 | 1.9 | 0.07 |
show slave status | 288 | 1.7 | 0.06 |
show master status | 285 | 1.6 | 0.06 |
show binlogs | 242 | 1.4 | 0.05 |
show storage engines | 86 | 0.5 | 0.02 |
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 | 15 | 0.1 | <0.01 |
update multi | 5 | <0.1 | <0.01 |
insert select | 3 | <0.1 | <0.01 |
show processlist | 2 | <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 |
show engine status | 1 | <0.1 | <0.01 |