Statements | # | ø per hour | % |
---|---|---|---|
select | 104 k | 2,454.8 | 81.84 |
set option | 11,585 | 273.5 | 9.12 |
show fields | 1,982 | 46.8 | 1.56 |
show keys | 1,926 | 45.5 | 1.52 |
update | 1,707 | 40.3 | 1.34 |
insert | 1,561 | 36.8 | 1.23 |
show tables | 1,390 | 32.8 | 1.09 |
change db | 845 | 19.9 | 0.66 |
show variables | 581 | 13.7 | 0.46 |
show create table | 514 | 12.1 | 0.40 |
delete | 419 | 9.9 | 0.33 |
show grants | 151 | 3.6 | 0.12 |
show binlogs | 79 | 1.9 | 0.06 |
begin | 43 | 1 | 0.03 |
commit | 43 | 1 | 0.03 |
show slave status | 37 | 0.9 | 0.03 |
stmt close | 36 | 0.8 | 0.03 |
stmt execute | 36 | 0.8 | 0.03 |
stmt prepare | 36 | 0.8 | 0.03 |
show binlog status | 33 | 0.8 | 0.03 |
create table | 20 | 0.5 | 0.02 |
show status | 15 | 0.4 | 0.01 |
show storage engines | 13 | 0.3 | 0.01 |
show table status | 13 | 0.3 | 0.01 |
show collations | 10 | 0.2 | 0.01 |
show processlist | 2 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |
truncate | 1 | <0.1 | <0.01 |