Statements | # | ø per hour | % |
---|---|---|---|
select | 11,383 k | 348.1 k | 85.71 |
show fields | 435 k | 13.3 k | 3.27 |
set option | 351 k | 10.7 k | 2.65 |
change db | 223 k | 6,810.3 | 1.68 |
show variables | 211 k | 6,462.6 | 1.59 |
show keys | 180 k | 5,503.9 | 1.36 |
show tables | 117 k | 3,587.7 | 0.88 |
show grants | 114 k | 3,471.9 | 0.85 |
show create table | 107 k | 3,265.3 | 0.80 |
show warnings | 105 k | 3,212.8 | 0.79 |
replace | 35,995 | 1,100.8 | 0.27 |
show binlogs | 9,005 | 275.4 | 0.07 |
update | 3,256 | 99.6 | 0.02 |
insert | 2,379 | 72.8 | 0.02 |
commit | 678 | 20.7 | 0.01 |
begin | 638 | 19.5 | <0.01 |
stmt prepare | 517 | 15.8 | <0.01 |
stmt execute | 517 | 15.8 | <0.01 |
show table status | 460 | 14.1 | <0.01 |
show storage engines | 397 | 12.1 | <0.01 |
stmt close | 368 | 11.3 | <0.01 |
delete | 340 | 10.4 | <0.01 |
show master status | 113 | 3.5 | <0.01 |
show slave status | 113 | 3.5 | <0.01 |
alter table | 29 | 0.9 | <0.01 |
show status | 19 | 0.6 | <0.01 |
create table | 14 | 0.4 | <0.01 |
create trigger | 2 | 0.1 | <0.01 |
show engine status | 1 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |
drop table | 1 | <0.1 | <0.01 |