Statements | # | ø per hour | % |
---|---|---|---|
select | 31,607 k | 234.2 k | 99.49 |
update | 28,335 | 209.9 | 0.09 |
insert | 24,290 | 180 | 0.08 |
show fields | 15,995 | 118.5 | 0.05 |
stmt execute | 15,854 | 117.5 | 0.05 |
stmt prepare | 15,680 | 116.2 | 0.05 |
stmt close | 14,277 | 105.8 | 0.04 |
show tables | 12,802 | 94.9 | 0.04 |
set option | 8,522 | 63.1 | 0.03 |
show keys | 6,696 | 49.6 | 0.02 |
change db | 4,509 | 33.4 | 0.01 |
commit | 3,999 | 29.6 | 0.01 |
begin | 3,797 | 28.1 | 0.01 |
delete | 1,718 | 12.7 | 0.01 |
show create table | 1,535 | 11.4 | <0.01 |
show variables | 1,467 | 10.9 | <0.01 |
show grants | 1,216 | 9 | <0.01 |
show storage engines | 481 | 3.6 | <0.01 |
show warnings | 269 | 2 | <0.01 |
show table status | 162 | 1.2 | <0.01 |
show slave status | 108 | 0.8 | <0.01 |
show master status | 105 | 0.8 | <0.01 |
show binlogs | 89 | 0.7 | <0.01 |
show procedure status | 10 | 0.1 | <0.01 |
show function status | 10 | 0.1 | <0.01 |
show status | 4 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |