Statements | # | ø per hour | % |
---|---|---|---|
select | 7,982 k | 25.6 k | 82.70 |
show fields | 416 k | 1,335.4 | 4.31 |
show tables | 350 k | 1,124.4 | 3.63 |
change db | 279 k | 895.9 | 2.89 |
set option | 210 k | 672.4 | 2.17 |
show variables | 137 k | 440.3 | 1.42 |
show keys | 69,553 | 223.2 | 0.72 |
show grants | 69,265 | 222.3 | 0.72 |
show create table | 68,662 | 220.4 | 0.71 |
show warnings | 68,389 | 219.5 | 0.71 |
replace | 590 | 1.9 | 0.01 |
show binlogs | 397 | 1.3 | <0.01 |
stmt prepare | 274 | 0.9 | <0.01 |
stmt close | 169 | 0.5 | <0.01 |
stmt execute | 169 | 0.5 | <0.01 |
show storage engines | 127 | 0.4 | <0.01 |
show slave status | 111 | 0.4 | <0.01 |
show master status | 105 | 0.3 | <0.01 |
show table status | 69 | 0.2 | <0.01 |
show status | 41 | 0.1 | <0.01 |
update | 21 | 0.1 | <0.01 |
show processlist | 6 | <0.1 | <0.01 |
show engine status | 3 | <0.1 | <0.01 |
flush | 2 | <0.1 | <0.01 |
insert | 1 | <0.1 | <0.01 |