Statements | # | ø per hour | % |
---|---|---|---|
select | 1,501 k | 2,717.2 | 77.10 |
show fields | 99,196 | 179.5 | 5.09 |
show tables | 96,463 | 174.6 | 4.95 |
change db | 70,128 | 126.9 | 3.60 |
show keys | 57,602 | 104.2 | 2.96 |
set option | 51,899 | 93.9 | 2.66 |
show variables | 21,184 | 38.3 | 1.09 |
replace | 15,549 | 28.1 | 0.80 |
show create table | 12,972 | 23.5 | 0.67 |
show warnings | 9,589 | 17.4 | 0.49 |
stmt execute | 2,918 | 5.3 | 0.15 |
stmt prepare | 2,918 | 5.3 | 0.15 |
stmt close | 2,821 | 5.1 | 0.14 |
show storage engines | 1,575 | 2.9 | 0.08 |
show grants | 204 | 0.4 | 0.01 |
show slave status | 187 | 0.3 | 0.01 |
show master status | 180 | 0.3 | 0.01 |
show table status | 166 | 0.3 | 0.01 |
insert | 156 | 0.3 | 0.01 |
update | 150 | 0.3 | 0.01 |
show status | 79 | 0.1 | <0.01 |
show binlogs | 70 | 0.1 | <0.01 |
delete | 22 | <0.1 | <0.01 |
show function status | 8 | <0.1 | <0.01 |
show procedure status | 8 | <0.1 | <0.01 |
show triggers | 8 | <0.1 | <0.01 |
alter table | 5 | <0.1 | <0.01 |
show engine status | 5 | <0.1 | <0.01 |
flush | 3 | <0.1 | <0.01 |
show processlist | 3 | <0.1 | <0.01 |
create table | 2 | <0.1 | <0.01 |
show collations | 1 | <0.1 | <0.01 |
show databases | 1 | <0.1 | <0.01 |
show open tables | 1 | <0.1 | <0.01 |