Statements | # | ø per hour | % |
---|---|---|---|
select | 1,579 k | 2,760.1 | 77.10 |
show fields | 104 k | 182.2 | 5.09 |
show tables | 103 k | 179.3 | 5.01 |
change db | 74,040 | 129.4 | 3.61 |
show keys | 59,889 | 104.7 | 2.92 |
set option | 54,753 | 95.7 | 2.67 |
show variables | 21,846 | 38.2 | 1.07 |
replace | 16,314 | 28.5 | 0.80 |
show create table | 13,351 | 23.3 | 0.65 |
show warnings | 9,796 | 17.1 | 0.48 |
stmt execute | 2,983 | 5.2 | 0.15 |
stmt prepare | 2,983 | 5.2 | 0.15 |
stmt close | 2,886 | 5 | 0.14 |
show storage engines | 1,641 | 2.9 | 0.08 |
show grants | 462 | 0.8 | 0.02 |
show slave status | 192 | 0.3 | 0.01 |
show master status | 185 | 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 | 121 | 0.2 | 0.01 |
show status | 85 | 0.1 | <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 | 4 | <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 |