Statements | # | ø per hour | % |
---|---|---|---|
select | 3,203 k | 19.5 k | 81.47 |
show fields | 173 k | 1,056.8 | 4.41 |
show tables | 162 k | 990 | 4.13 |
change db | 123 k | 747.4 | 3.12 |
set option | 91,317 | 556.8 | 2.32 |
show variables | 46,454 | 283.2 | 1.18 |
show keys | 40,647 | 247.8 | 1.03 |
show grants | 29,769 | 181.5 | 0.76 |
show create table | 25,563 | 155.9 | 0.65 |
show warnings | 22,200 | 135.4 | 0.56 |
replace | 9,515 | 58 | 0.24 |
show storage engines | 1,492 | 9.1 | 0.04 |
stmt prepare | 703 | 4.3 | 0.02 |
stmt execute | 702 | 4.3 | 0.02 |
stmt close | 667 | 4.1 | 0.02 |
show binlogs | 412 | 2.5 | 0.01 |
show slave status | 301 | 1.8 | 0.01 |
show master status | 299 | 1.8 | 0.01 |
show table status | 195 | 1.2 | <0.01 |
show status | 31 | 0.2 | <0.01 |
update | 12 | 0.1 | <0.01 |
delete | 7 | <0.1 | <0.01 |
insert | 4 | <0.1 | <0.01 |
show processlist | 4 | <0.1 | <0.01 |
show engine status | 3 | <0.1 | <0.01 |
flush | 2 | <0.1 | <0.01 |