Statements | # | ø per hour | % |
---|---|---|---|
select | 33,805 k | 240.4 k | 99.17 |
show tables | 44,770 | 318.4 | 0.13 |
update | 34,613 | 246.2 | 0.10 |
show fields | 31,925 | 227 | 0.09 |
insert | 29,664 | 211 | 0.09 |
set option | 28,637 | 203.7 | 0.08 |
show keys | 19,048 | 135.5 | 0.06 |
stmt execute | 18,558 | 132 | 0.05 |
stmt prepare | 18,338 | 130.4 | 0.05 |
stmt close | 16,804 | 119.5 | 0.05 |
change db | 12,978 | 92.3 | 0.04 |
show variables | 6,735 | 47.9 | 0.02 |
show create table | 5,440 | 38.7 | 0.02 |
commit | 4,210 | 29.9 | 0.01 |
begin | 3,995 | 28.4 | 0.01 |
delete | 1,999 | 14.2 | 0.01 |
show grants | 1,973 | 14 | 0.01 |
show warnings | 1,588 | 11.3 | <0.01 |
show storage engines | 1,483 | 10.5 | <0.01 |
show table status | 238 | 1.7 | <0.01 |
show binlogs | 152 | 1.1 | <0.01 |
show slave status | 150 | 1.1 | <0.01 |
show master status | 146 | 1 | <0.01 |
show status | 20 | 0.1 | <0.01 |
show procedure status | 10 | 0.1 | <0.01 |
show function status | 10 | 0.1 | <0.01 |
show processlist | 2 | <0.1 | <0.01 |
show engine status | 1 | <0.1 | <0.01 |