Press Ctrl+Enter to execute queryPress Enter to execute query
Statements | # | ø per hour | % |
---|---|---|---|
select | 13,103 k | 53.3 k | 74.68 |
delete | 1,002 k | 4,072.4 | 5.71 |
insert | 502 k | 2,042.1 | 2.86 |
update | 501 k | 2,037.2 | 2.86 |
show fields | 467 k | 1,896.8 | 2.66 |
show keys | 453 k | 1,842.4 | 2.58 |
change db | 376 k | 1,530.1 | 2.15 |
show tables | 280 k | 1,136.7 | 1.59 |
set option | 253 k | 1,028.6 | 1.44 |
show create table | 198 k | 806 | 1.13 |
flush | 125 k | 509.4 | 0.71 |
show variables | 62,653 | 254.6 | 0.36 |
show grants | 50,693 | 206 | 0.29 |
replace | 36,833 | 149.7 | 0.21 |
show slave status | 35,187 | 143 | 0.20 |
show master status | 34,435 | 140 | 0.20 |
show create proc | 27,930 | 113.5 | 0.16 |
show binlogs | 12,137 | 49.3 | 0.07 |
show create func | 8,645 | 35.1 | 0.05 |
show plugins | 6,539 | 26.6 | 0.04 |
show storage engines | 3,239 | 13.2 | 0.02 |
call procedure | 1,154 | 4.7 | 0.01 |
stmt prepare | 886 | 3.6 | 0.01 |
stmt execute | 885 | 3.6 | 0.01 |
stmt close | 851 | 3.5 | <0.01 |
show status | 769 | 3.1 | <0.01 |
show table status | 740 | 3 | <0.01 |
insert select | 106 | 0.4 | <0.01 |
drop table | 106 | 0.4 | <0.01 |
create temporary table | 106 | 0.4 | <0.01 |
show processlist | 84 | 0.3 | <0.01 |