Statements | # | ø per hour | % |
---|---|---|---|
select | 6,954 k | 22.5 k | 82.72 |
show fields | 362 k | 1,172.4 | 4.31 |
show tables | 304 k | 986 | 3.62 |
change db | 243 k | 785.9 | 2.89 |
set option | 182 k | 590.4 | 2.17 |
show variables | 120 k | 387.8 | 1.42 |
show grants | 60,389 | 195.6 | 0.72 |
show keys | 60,172 | 194.9 | 0.72 |
show create table | 59,861 | 193.8 | 0.71 |
show warnings | 59,746 | 193.5 | 0.71 |
show binlogs | 317 | 1 | <0.01 |
replace | 245 | 0.8 | <0.01 |
stmt prepare | 175 | 0.6 | <0.01 |
stmt close | 115 | 0.4 | <0.01 |
stmt execute | 115 | 0.4 | <0.01 |
show slave status | 96 | 0.3 | <0.01 |
show master status | 91 | 0.3 | <0.01 |
show storage engines | 49 | 0.2 | <0.01 |
show table status | 49 | 0.2 | <0.01 |
show status | 29 | 0.1 | <0.01 |
update | 21 | 0.1 | <0.01 |
show processlist | 4 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |
insert | 1 | <0.1 | <0.01 |
show engine status | 1 | <0.1 | <0.01 |