Statements | # | ø per hour | % |
---|---|---|---|
select | 31,393 | 637.2 | 80.65 |
show tables | 2,239 | 45.4 | 5.75 |
show fields | 1,529 | 31 | 3.93 |
change db | 1,398 | 28.4 | 3.59 |
set option | 1,152 | 23.4 | 2.96 |
show keys | 315 | 6.4 | 0.81 |
show grants | 202 | 4.1 | 0.52 |
show variables | 160 | 3.2 | 0.41 |
show create table | 103 | 2.1 | 0.26 |
show binlogs | 90 | 1.8 | 0.23 |
show slave status | 49 | 1 | 0.13 |
show master status | 46 | 0.9 | 0.12 |
stmt prepare | 44 | 0.9 | 0.11 |
stmt close | 43 | 0.9 | 0.11 |
stmt execute | 43 | 0.9 | 0.11 |
show warnings | 36 | 0.7 | 0.09 |
replace | 24 | 0.5 | 0.06 |
show storage engines | 15 | 0.3 | 0.04 |
delete | 12 | 0.2 | 0.03 |
show status | 12 | 0.2 | 0.03 |
create table | 5 | 0.1 | 0.01 |
update | 3 | 0.1 | 0.01 |
create db | 2 | <0.1 | 0.01 |
insert | 2 | <0.1 | 0.01 |
show processlist | 2 | <0.1 | 0.01 |
show table status | 2 | <0.1 | 0.01 |
drop db | 1 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |
show engine status | 1 | <0.1 | <0.01 |