Statements | # | ø per hour | % |
---|---|---|---|
select | 51,855 k | 288.8 k | 79.88 |
show fields | 3,233 k | 18 k | 4.98 |
show tables | 2,708 k | 15.1 k | 4.17 |
change db | 2,160 k | 12 k | 3.33 |
set option | 1,621 k | 9,026.4 | 2.50 |
show variables | 1,068 k | 5,946.1 | 1.64 |
show keys | 617 k | 3,434.4 | 0.95 |
show grants | 539 k | 3,003.7 | 0.83 |
show create table | 536 k | 2,985.6 | 0.83 |
show warnings | 533 k | 2,968.4 | 0.82 |
replace | 44,146 | 245.8 | 0.07 |
update | 1,482 | 8.3 | <0.01 |
show storage engines | 1,362 | 7.6 | <0.01 |
stmt prepare | 429 | 2.4 | <0.01 |
show binlogs | 393 | 2.2 | <0.01 |
insert | 328 | 1.8 | <0.01 |
stmt close | 314 | 1.7 | <0.01 |
stmt execute | 314 | 1.7 | <0.01 |
delete | 189 | 1.1 | <0.01 |
show table status | 189 | 1.1 | <0.01 |
show slave status | 124 | 0.7 | <0.01 |
show master status | 119 | 0.7 | <0.01 |
show status | 30 | 0.2 | <0.01 |
delete multi | 12 | 0.1 | <0.01 |
flush | 5 | <0.1 | <0.01 |
show engine status | 4 | <0.1 | <0.01 |
show processlist | 3 | <0.1 | <0.01 |
alter table | 2 | <0.1 | <0.01 |
create db | 2 | <0.1 | <0.01 |
create table | 2 | <0.1 | <0.01 |
drop db | 2 | <0.1 | <0.01 |
insert select | 2 | <0.1 | <0.01 |
reset | 2 | <0.1 | <0.01 |
show databases | 2 | <0.1 | <0.01 |
truncate | 2 | <0.1 | <0.01 |
grant | 1 | <0.1 | <0.01 |