Press Ctrl+Enter to execute queryPress Enter to execute query
Statements | # | ø per hour | % |
---|---|---|---|
select | 30,402 k | 119.9 k | 68.08 |
show keys | 2,612 k | 10.3 k | 5.85 |
delete | 2,439 k | 9,615.5 | 5.46 |
show fields | 2,181 k | 8,597 | 4.88 |
change db | 1,485 k | 5,853.7 | 3.33 |
insert | 1,221 k | 4,815.5 | 2.74 |
update | 1,220 k | 4,807.8 | 2.73 |
show create table | 1,025 k | 4,040.7 | 2.30 |
set option | 613 k | 2,415.7 | 1.37 |
show tables | 495 k | 1,952.5 | 1.11 |
flush | 305 k | 1,202.6 | 0.68 |
show slave status | 139 k | 547.4 | 0.31 |
show master status | 138 k | 543.3 | 0.31 |
show variables | 101 k | 399.6 | 0.23 |
show grants | 95,763 | 377.5 | 0.21 |
replace | 58,714 | 231.5 | 0.13 |
show binlogs | 45,294 | 178.6 | 0.10 |
show create proc | 38,052 | 150 | 0.09 |
show plugins | 12,857 | 50.7 | 0.03 |
show create func | 11,778 | 46.4 | 0.03 |
show storage engines | 9,329 | 36.8 | 0.02 |
call procedure | 1,225 | 4.8 | <0.01 |
show status | 1,192 | 4.7 | <0.01 |
show table status | 940 | 3.7 | <0.01 |
stmt prepare | 902 | 3.6 | <0.01 |
stmt execute | 901 | 3.6 | <0.01 |
stmt close | 867 | 3.4 | <0.01 |
show processlist | 173 | 0.7 | <0.01 |
drop table | 117 | 0.5 | <0.01 |
insert select | 117 | 0.5 | <0.01 |
create temporary table | 117 | 0.5 | <0.01 |