Statements | # | ø per hour | % |
---|---|---|---|
select | 10,482 k | 338 k | 85.33 |
show fields | 414 k | 13.3 k | 3.37 |
set option | 332 k | 10.7 k | 2.70 |
change db | 212 k | 6,824.1 | 1.72 |
show variables | 202 k | 6,502.2 | 1.64 |
show keys | 171 k | 5,520.5 | 1.39 |
show tables | 111 k | 3,569.5 | 0.90 |
show grants | 109 k | 3,522.7 | 0.89 |
show create table | 101 k | 3,271.5 | 0.83 |
show warnings | 101 k | 3,244 | 0.82 |
replace | 32,486 | 1,047.6 | 0.26 |
show binlogs | 8,766 | 282.7 | 0.07 |
update | 2,954 | 95.3 | 0.02 |
insert | 2,194 | 70.8 | 0.02 |
commit | 576 | 18.6 | <0.01 |
begin | 541 | 17.4 | <0.01 |
stmt prepare | 514 | 16.6 | <0.01 |
stmt execute | 514 | 16.6 | <0.01 |
stmt close | 366 | 11.8 | <0.01 |
delete | 323 | 10.4 | <0.01 |
show storage engines | 184 | 5.9 | <0.01 |
show table status | 159 | 5.1 | <0.01 |
show slave status | 105 | 3.4 | <0.01 |
show master status | 105 | 3.4 | <0.01 |
alter table | 29 | 0.9 | <0.01 |
create table | 14 | 0.5 | <0.01 |
show status | 13 | 0.4 | <0.01 |
create trigger | 2 | 0.1 | <0.01 |
drop table | 1 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |