Statements | # | ø per hour | % |
---|---|---|---|
select | 1,284 k | 20.1 k | 77.30 |
show tables | 88,607 | 1,387.9 | 5.33 |
show fields | 85,145 | 1,333.7 | 5.13 |
change db | 62,136 | 973.3 | 3.74 |
set option | 46,683 | 731.2 | 2.81 |
show keys | 40,806 | 639.2 | 2.46 |
show variables | 14,601 | 228.7 | 0.88 |
replace | 14,577 | 228.3 | 0.88 |
show create table | 10,458 | 163.8 | 0.63 |
show warnings | 6,208 | 97.2 | 0.37 |
show storage engines | 2,096 | 32.8 | 0.13 |
stmt close | 1,583 | 24.8 | 0.10 |
stmt execute | 1,583 | 24.8 | 0.10 |
stmt prepare | 1,583 | 24.8 | 0.10 |
show table status | 214 | 3.4 | 0.01 |
show grants | 212 | 3.3 | 0.01 |
show slave status | 132 | 2.1 | 0.01 |
show master status | 126 | 2 | 0.01 |
show binlogs | 125 | 2 | 0.01 |
delete | 49 | 0.8 | <0.01 |
insert | 34 | 0.5 | <0.01 |
show status | 34 | 0.5 | <0.01 |
show create func | 14 | 0.2 | <0.01 |
show create proc | 14 | 0.2 | <0.01 |
update | 10 | 0.2 | <0.01 |
show engine status | 4 | 0.1 | <0.01 |
show processlist | 4 | 0.1 | <0.01 |
alter table | 2 | <0.1 | <0.01 |
flush | 2 | <0.1 | <0.01 |