Statements | # | ø per hour | % |
---|---|---|---|
select | 3,709 k | 22.2 k | 81.65 |
show fields | 199 k | 1,195.6 | 4.39 |
show tables | 184 k | 1,105.9 | 4.06 |
change db | 140 k | 840.3 | 3.09 |
set option | 104 k | 626.4 | 2.30 |
show variables | 55,063 | 330.1 | 1.21 |
show keys | 45,013 | 269.9 | 0.99 |
show grants | 34,156 | 204.8 | 0.75 |
show create table | 29,908 | 179.3 | 0.66 |
show warnings | 26,486 | 158.8 | 0.58 |
replace | 9,521 | 57.1 | 0.21 |
show storage engines | 1,501 | 9 | 0.03 |
stmt prepare | 703 | 4.2 | 0.02 |
stmt execute | 702 | 4.2 | 0.02 |
stmt close | 667 | 4 | 0.01 |
show binlogs | 445 | 2.7 | 0.01 |
show slave status | 311 | 1.9 | 0.01 |
show master status | 308 | 1.8 | 0.01 |
show table status | 195 | 1.2 | <0.01 |
show status | 40 | 0.2 | <0.01 |
update | 12 | 0.1 | <0.01 |
delete | 7 | <0.1 | <0.01 |
show processlist | 5 | <0.1 | <0.01 |
insert | 4 | <0.1 | <0.01 |
show engine status | 3 | <0.1 | <0.01 |
flush | 2 | <0.1 | <0.01 |