Statements | # | ø per hour | % |
---|---|---|---|
select | 63,956 | 1,043.4 | 58.57 |
show tables | 11,594 | 189.2 | 10.62 |
show keys | 8,533 | 139.2 | 7.81 |
set option | 8,103 | 132.2 | 7.42 |
show fields | 7,564 | 123.4 | 6.93 |
change db | 3,009 | 49.1 | 2.76 |
show variables | 2,067 | 33.7 | 1.89 |
show create table | 1,396 | 22.8 | 1.28 |
show grants | 1,102 | 18 | 1.01 |
show warnings | 574 | 9.4 | 0.53 |
show storage engines | 476 | 7.8 | 0.44 |
show binlogs | 241 | 3.9 | 0.22 |
show master status | 87 | 1.4 | 0.08 |
show replica status | 87 | 1.4 | 0.08 |
show slave status | 87 | 1.4 | 0.08 |
stmt execute | 60 | 1 | 0.05 |
stmt close | 60 | 1 | 0.05 |
stmt prepare | 60 | 1 | 0.05 |
show status | 41 | 0.7 | 0.04 |
create table | 35 | 0.6 | 0.03 |
show table status | 18 | 0.3 | 0.02 |
show binlog events | 8 | 0.1 | 0.01 |
show replicas | 8 | 0.1 | 0.01 |
show slave hosts | 8 | 0.1 | 0.01 |
show processlist | 5 | 0.1 | <0.01 |
flush | 4 | 0.1 | <0.01 |
show engine status | 4 | 0.1 | <0.01 |
create db | 1 | <0.1 | <0.01 |