Statements | # | ø per hour | % |
---|---|---|---|
select | 1,580 k | 2,760.9 | 77.10 |
show fields | 104 k | 182.3 | 5.09 |
show tables | 103 k | 179.4 | 5.01 |
change db | 74,067 | 129.5 | 3.62 |
show keys | 59,891 | 104.7 | 2.92 |
set option | 54,774 | 95.7 | 2.67 |
show variables | 21,852 | 38.2 | 1.07 |
replace | 16,315 | 28.5 | 0.80 |
show create table | 13,351 | 23.3 | 0.65 |
show warnings | 9,796 | 17.1 | 0.48 |
stmt execute | 2,992 | 5.2 | 0.15 |
stmt prepare | 2,992 | 5.2 | 0.15 |
stmt close | 2,895 | 5.1 | 0.14 |
show storage engines | 1,642 | 2.9 | 0.08 |
show grants | 466 | 0.8 | 0.02 |
show slave status | 195 | 0.3 | 0.01 |
show master status | 188 | 0.3 | 0.01 |
show table status | 185 | 0.3 | 0.01 |
update | 168 | 0.3 | 0.01 |
insert | 165 | 0.3 | 0.01 |
show binlogs | 126 | 0.2 | 0.01 |
show status | 89 | 0.2 | <0.01 |
delete | 22 | <0.1 | <0.01 |
show function status | 9 | <0.1 | <0.01 |
show procedure status | 9 | <0.1 | <0.01 |
show triggers | 9 | <0.1 | <0.01 |
show engine status | 7 | <0.1 | <0.01 |
alter table | 6 | <0.1 | <0.01 |
show processlist | 5 | <0.1 | <0.01 |
flush | 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 |