Statements | # | ø per hour | % |
---|---|---|---|
select | 124 M | 205.6 k | 79.88 |
show fields | 6,693 k | 11.1 k | 4.33 |
show tables | 5,667 k | 9,434.6 | 3.66 |
show keys | 5,065 k | 8,432.7 | 3.28 |
change db | 4,502 k | 7,495.1 | 2.91 |
set option | 3,391 k | 5,646.3 | 2.19 |
show variables | 2,199 k | 3,660.6 | 1.42 |
show grants | 1,101 k | 1,833.4 | 0.71 |
show create table | 1,100 k | 1,832.1 | 0.71 |
show warnings | 1,099 k | 1,829.3 | 0.71 |
replace | 272 k | 452.8 | 0.18 |
show binlogs | 17,227 | 28.7 | 0.01 |
update | 3,238 | 5.4 | <0.01 |
show storage engines | 506 | 0.8 | <0.01 |
show slave status | 146 | 0.2 | <0.01 |
stmt close | 146 | 0.2 | <0.01 |
stmt execute | 146 | 0.2 | <0.01 |
stmt prepare | 146 | 0.2 | <0.01 |
show master status | 140 | 0.2 | <0.01 |
show table status | 124 | 0.2 | <0.01 |
insert | 120 | 0.2 | <0.01 |
show collations | 40 | 0.1 | <0.01 |
show status | 28 | <0.1 | <0.01 |
create table | 16 | <0.1 | <0.01 |
begin | 4 | <0.1 | <0.01 |
commit | 4 | <0.1 | <0.01 |
show processlist | 4 | <0.1 | <0.01 |
flush | 2 | <0.1 | <0.01 |
show engine status | 1 | <0.1 | <0.01 |