Press Ctrl+Enter to execute queryPress Enter to execute query
Statements | # | ø per hour | % |
---|---|---|---|
select | 21,153 k | 84.8 k | 71.13 |
delete | 1,700 k | 6,812.4 | 5.72 |
show keys | 1,250 k | 5,007.8 | 4.20 |
show fields | 1,105 k | 4,428.9 | 3.72 |
insert | 852 k | 3,413.1 | 2.86 |
update | 850 k | 3,406.8 | 2.86 |
change db | 817 k | 3,275.2 | 2.75 |
show create table | 504 k | 2,017.6 | 1.69 |
set option | 428 k | 1,714.3 | 1.44 |
show tables | 408 k | 1,633.7 | 1.37 |
flush | 213 k | 852.1 | 0.72 |
show variables | 84,623 | 339.1 | 0.28 |
show slave status | 78,601 | 315 | 0.26 |
show master status | 77,656 | 311.2 | 0.26 |
show grants | 72,737 | 291.5 | 0.24 |
replace | 49,406 | 198 | 0.17 |
show create proc | 36,372 | 145.7 | 0.12 |
show binlogs | 26,431 | 105.9 | 0.09 |
show create func | 11,258 | 45.1 | 0.04 |
show plugins | 9,987 | 40 | 0.03 |
show storage engines | 6,783 | 27.2 | 0.02 |
call procedure | 1,202 | 4.8 | <0.01 |
show status | 1,079 | 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 | 819 | 3.3 | <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 |