Press Ctrl+Enter to execute queryPress Enter to execute query
Statements | # | ø per hour | % |
---|---|---|---|
select | 20,820 k | 83.5 k | 71.25 |
delete | 1,655 k | 6,635.9 | 5.66 |
show keys | 1,232 k | 4,940.5 | 4.22 |
show fields | 1,089 k | 4,365 | 3.73 |
insert | 829 k | 3,324.8 | 2.84 |
update | 828 k | 3,318.6 | 2.83 |
change db | 800 k | 3,209.8 | 2.74 |
show create table | 496 k | 1,989.5 | 1.70 |
set option | 417 k | 1,670.2 | 1.43 |
show tables | 400 k | 1,603.6 | 1.37 |
flush | 207 k | 830 | 0.71 |
show variables | 82,903 | 332.4 | 0.28 |
show slave status | 75,985 | 304.7 | 0.26 |
show master status | 75,049 | 300.9 | 0.26 |
show grants | 71,200 | 285.5 | 0.24 |
replace | 48,312 | 193.7 | 0.17 |
show create proc | 36,036 | 144.5 | 0.12 |
show binlogs | 25,387 | 101.8 | 0.09 |
show create func | 11,154 | 44.7 | 0.04 |
show plugins | 9,694 | 38.9 | 0.03 |
show storage engines | 6,505 | 26.1 | 0.02 |
call procedure | 1,202 | 4.8 | <0.01 |
show status | 1,064 | 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 | 807 | 3.2 | <0.01 |
show processlist | 152 | 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 |