Statements | # | ø per hour | % |
---|---|---|---|
select | 264 k | 978.8 | 79.80 |
show tables | 17,684 | 65.6 | 5.35 |
show fields | 14,150 | 52.5 | 4.28 |
change db | 12,142 | 45.1 | 3.67 |
set option | 9,989 | 37.1 | 3.02 |
show keys | 4,603 | 17.1 | 1.39 |
show grants | 1,926 | 7.1 | 0.58 |
show create table | 1,237 | 4.6 | 0.37 |
replace | 1,195 | 4.4 | 0.36 |
show variables | 1,184 | 4.4 | 0.36 |
show binlogs | 385 | 1.4 | 0.12 |
show warnings | 348 | 1.3 | 0.11 |
show storage engines | 308 | 1.1 | 0.09 |
stmt close | 293 | 1.1 | 0.09 |
stmt execute | 293 | 1.1 | 0.09 |
stmt prepare | 293 | 1.1 | 0.09 |
update | 213 | 0.8 | 0.06 |
show slave status | 189 | 0.7 | 0.06 |
show master status | 179 | 0.7 | 0.05 |
show table status | 102 | 0.4 | 0.03 |
show status | 24 | 0.1 | 0.01 |
insert | 22 | 0.1 | 0.01 |
delete | 6 | <0.1 | <0.01 |
begin | 2 | <0.1 | <0.01 |
commit | 2 | <0.1 | <0.01 |
show processlist | 2 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |
show engine status | 1 | <0.1 | <0.01 |