Statements | # | ø per hour | % |
---|---|---|---|
select | 1,263 k | 29.4 k | 77.32 |
show tables | 87,080 | 2,027.7 | 5.33 |
show fields | 83,865 | 1,952.8 | 5.13 |
change db | 61,223 | 1,425.6 | 3.75 |
set option | 45,890 | 1,068.6 | 2.81 |
show keys | 40,340 | 939.3 | 2.47 |
replace | 14,566 | 339.2 | 0.89 |
show variables | 14,515 | 338 | 0.89 |
show create table | 10,344 | 240.9 | 0.63 |
show warnings | 6,195 | 144.3 | 0.38 |
show storage engines | 2,074 | 48.3 | 0.13 |
stmt close | 1,267 | 29.5 | 0.08 |
stmt execute | 1,267 | 29.5 | 0.08 |
stmt prepare | 1,267 | 29.5 | 0.08 |
show table status | 214 | 5 | 0.01 |
show slave status | 114 | 2.7 | 0.01 |
show master status | 110 | 2.6 | 0.01 |
show grants | 74 | 1.7 | <0.01 |
delete | 49 | 1.1 | <0.01 |
show binlogs | 32 | 0.7 | <0.01 |
insert | 22 | 0.5 | <0.01 |
show status | 20 | 0.5 | <0.01 |
show create func | 14 | 0.3 | <0.01 |
show create proc | 14 | 0.3 | <0.01 |
update | 7 | 0.2 | <0.01 |
show engine status | 2 | <0.1 | <0.01 |
show processlist | 2 | <0.1 | <0.01 |
flush | 1 | <0.1 | <0.01 |