Statements | # | ø per hour | % |
---|---|---|---|
select | 11,957 k | 349.8 k | 85.87 |
show fields | 450 k | 13.2 k | 3.23 |
set option | 366 k | 10.7 k | 2.63 |
change db | 231 k | 6,749.3 | 1.66 |
show variables | 218 k | 6,387.2 | 1.57 |
show keys | 186 k | 5,445.1 | 1.34 |
show tables | 122 k | 3,572.2 | 0.88 |
show grants | 117 k | 3,410.3 | 0.84 |
show create table | 111 k | 3,234.8 | 0.79 |
show warnings | 108 k | 3,167.7 | 0.78 |
replace | 38,650 | 1,130.7 | 0.28 |
show binlogs | 9,179 | 268.5 | 0.07 |
update | 3,443 | 100.7 | 0.02 |
insert | 2,513 | 73.5 | 0.02 |
commit | 738 | 21.6 | 0.01 |
begin | 676 | 19.8 | <0.01 |
show table status | 674 | 19.7 | <0.01 |
show storage engines | 563 | 16.5 | <0.01 |
stmt execute | 519 | 15.2 | <0.01 |
stmt prepare | 519 | 15.2 | <0.01 |
delete | 388 | 11.4 | <0.01 |
stmt close | 369 | 10.8 | <0.01 |
show master status | 122 | 3.6 | <0.01 |
show slave status | 122 | 3.6 | <0.01 |
alter table | 29 | 0.8 | <0.01 |
show status | 24 | 0.7 | <0.01 |
create table | 14 | 0.4 | <0.01 |
show engine status | 2 | 0.1 | <0.01 |
create trigger | 2 | 0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |
drop table | 1 | <0.1 | <0.01 |