Statements | # | ø per hour | % |
---|---|---|---|
select | 31,127 | 8,007.5 | 77.67 |
show tables | 1,945 | 500.4 | 4.85 |
show fields | 1,584 | 407.5 | 3.95 |
change db | 1,347 | 346.5 | 3.36 |
set option | 1,050 | 270.1 | 2.62 |
stmt execute | 524 | 134.8 | 1.31 |
stmt prepare | 524 | 134.8 | 1.31 |
stmt close | 483 | 124.3 | 1.21 |
show keys | 316 | 81.3 | 0.79 |
show variables | 300 | 77.2 | 0.75 |
show grants | 224 | 57.6 | 0.56 |
show create table | 161 | 41.4 | 0.40 |
show warnings | 122 | 31.4 | 0.30 |
replace | 85 | 21.9 | 0.21 |
insert | 72 | 18.5 | 0.18 |
show binlogs | 55 | 14.1 | 0.14 |
update | 41 | 10.5 | 0.10 |
delete | 40 | 10.3 | 0.10 |
show slave status | 27 | 6.9 | 0.07 |
show master status | 24 | 6.2 | 0.06 |
show table status | 10 | 2.6 | 0.02 |
show storage engines | 9 | 2.3 | 0.02 |
show status | 7 | 1.8 | 0.02 |
flush | 1 | 0.3 | <0.01 |