Statements | # | ø per hour | % |
---|---|---|---|
select | 105 k | 2,271.1 | 81.71 |
set option | 11,615 | 252.2 | 9.08 |
show fields | 2,067 | 44.9 | 1.62 |
show keys | 2,011 | 43.7 | 1.57 |
update | 1,707 | 37.1 | 1.33 |
insert | 1,561 | 33.9 | 1.22 |
show tables | 1,443 | 31.3 | 1.13 |
change db | 880 | 19.1 | 0.69 |
show variables | 587 | 12.7 | 0.46 |
show create table | 514 | 11.2 | 0.40 |
delete | 419 | 9.1 | 0.33 |
show grants | 161 | 3.5 | 0.13 |
show binlogs | 88 | 1.9 | 0.07 |
begin | 43 | 0.9 | 0.03 |
commit | 43 | 0.9 | 0.03 |
show slave status | 40 | 0.9 | 0.03 |
show binlog status | 36 | 0.8 | 0.03 |
stmt close | 36 | 0.8 | 0.03 |
stmt execute | 36 | 0.8 | 0.03 |
stmt prepare | 36 | 0.8 | 0.03 |
create table | 20 | 0.4 | 0.02 |
show status | 19 | 0.4 | 0.01 |
show storage engines | 15 | 0.3 | 0.01 |
show table status | 13 | 0.3 | 0.01 |
show collations | 10 | 0.2 | 0.01 |
show processlist | 3 | 0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |
truncate | 1 | <0.1 | <0.01 |