Press Ctrl+Enter to execute queryPress Enter to execute query
Statements | # | ø per hour | % |
---|---|---|---|
select | 20,990 k | 84.1 k | 71.24 |
delete | 1,676 k | 6,720.1 | 5.69 |
show keys | 1,234 k | 4,947 | 4.19 |
show fields | 1,092 k | 4,377.8 | 3.71 |
insert | 840 k | 3,366.9 | 2.85 |
update | 838 k | 3,360.7 | 2.85 |
change db | 806 k | 3,232.2 | 2.74 |
show create table | 498 k | 1,994.6 | 1.69 |
set option | 422 k | 1,691.2 | 1.43 |
show tables | 405 k | 1,624 | 1.37 |
flush | 210 k | 840.5 | 0.71 |
show variables | 83,972 | 336.6 | 0.28 |
show slave status | 76,628 | 307.2 | 0.26 |
show master status | 75,685 | 303.4 | 0.26 |
show grants | 71,943 | 288.4 | 0.24 |
replace | 49,026 | 196.5 | 0.17 |
show create proc | 36,330 | 145.6 | 0.12 |
show binlogs | 25,781 | 103.4 | 0.09 |
show create func | 11,245 | 45.1 | 0.04 |
show plugins | 9,879 | 39.6 | 0.03 |
show storage engines | 6,695 | 26.8 | 0.02 |
call procedure | 1,202 | 4.8 | <0.01 |
show status | 1,073 | 4.3 | <0.01 |
stmt prepare | 895 | 3.6 | <0.01 |
stmt execute | 894 | 3.6 | <0.01 |
stmt close | 860 | 3.4 | <0.01 |
show table status | 810 | 3.2 | <0.01 |
show processlist | 154 | 0.6 | <0.01 |
drop table | 109 | 0.4 | <0.01 |
create temporary table | 109 | 0.4 | <0.01 |
insert select | 109 | 0.4 | <0.01 |