Statements | # | ø per hour | % |
---|---|---|---|
select | 270 k | 1,000.5 | 79.68 |
show tables | 18,105 | 67.2 | 5.35 |
show fields | 14,597 | 54.2 | 4.31 |
change db | 12,477 | 46.3 | 3.69 |
set option | 10,202 | 37.8 | 3.01 |
show keys | 4,882 | 18.1 | 1.44 |
show grants | 1,993 | 7.4 | 0.59 |
show create table | 1,249 | 4.6 | 0.37 |
replace | 1,235 | 4.6 | 0.36 |
show variables | 1,223 | 4.5 | 0.36 |
show binlogs | 397 | 1.5 | 0.12 |
show warnings | 351 | 1.3 | 0.10 |
show storage engines | 332 | 1.2 | 0.10 |
stmt close | 328 | 1.2 | 0.10 |
stmt execute | 328 | 1.2 | 0.10 |
stmt prepare | 328 | 1.2 | 0.10 |
update | 213 | 0.8 | 0.06 |
show slave status | 195 | 0.7 | 0.06 |
show master status | 185 | 0.7 | 0.05 |
show table status | 106 | 0.4 | 0.03 |
show status | 32 | 0.1 | 0.01 |
insert | 22 | 0.1 | 0.01 |
delete | 6 | <0.1 | <0.01 |
show processlist | 4 | <0.1 | <0.01 |
begin | 2 | <0.1 | <0.01 |
commit | 2 | <0.1 | <0.01 |
flush | 2 | <0.1 | <0.01 |
show engine status | 2 | <0.1 | <0.01 |