Statements | # | ø per hour | % |
---|---|---|---|
select | 11,922 | 102.8 | 52.82 |
show keys | 2,435 | 21 | 10.79 |
show fields | 2,191 | 18.9 | 9.71 |
set option | 1,854 | 16 | 8.21 |
show tables | 1,841 | 15.9 | 8.16 |
change db | 945 | 8.1 | 4.19 |
show variables | 294 | 2.5 | 1.30 |
show create table | 293 | 2.5 | 1.30 |
show grants | 220 | 1.9 | 0.97 |
show storage engines | 142 | 1.2 | 0.63 |
show binlogs | 86 | 0.7 | 0.38 |
show master status | 44 | 0.4 | 0.19 |
show replica status | 44 | 0.4 | 0.19 |
show slave status | 44 | 0.4 | 0.19 |
show warnings | 36 | 0.3 | 0.16 |
create table | 35 | 0.3 | 0.16 |
stmt execute | 35 | 0.3 | 0.16 |
stmt close | 35 | 0.3 | 0.16 |
stmt prepare | 35 | 0.3 | 0.16 |
show status | 17 | 0.1 | 0.08 |
flush | 8 | 0.1 | 0.04 |
show replicas | 4 | <0.1 | 0.02 |
show slave hosts | 4 | <0.1 | 0.02 |
show binlog events | 3 | <0.1 | 0.01 |
show processlist | 3 | <0.1 | 0.01 |
create db | 1 | <0.1 | <0.01 |
show engine status | 1 | <0.1 | <0.01 |
show table status | 1 | <0.1 | <0.01 |