Statements | # | ø per hour | % |
---|---|---|---|
select | 81,344 | 1,249.2 | 55.85 |
show tables | 16,724 | 256.8 | 11.48 |
show keys | 11,746 | 180.4 | 8.06 |
set option | 11,643 | 178.8 | 7.99 |
show fields | 10,808 | 166 | 7.42 |
change db | 4,150 | 63.7 | 2.85 |
show variables | 3,167 | 48.6 | 2.17 |
show create table | 1,985 | 30.5 | 1.36 |
show grants | 1,523 | 23.4 | 1.05 |
show warnings | 942 | 14.5 | 0.65 |
show storage engines | 564 | 8.7 | 0.39 |
show binlogs | 326 | 5 | 0.22 |
show master status | 104 | 1.6 | 0.07 |
show replica status | 104 | 1.6 | 0.07 |
show slave status | 104 | 1.6 | 0.07 |
stmt execute | 76 | 1.2 | 0.05 |
stmt close | 76 | 1.2 | 0.05 |
stmt prepare | 76 | 1.2 | 0.05 |
show status | 59 | 0.9 | 0.04 |
show table status | 45 | 0.7 | 0.03 |
create table | 35 | 0.5 | 0.02 |
show replicas | 9 | 0.1 | 0.01 |
show slave hosts | 9 | 0.1 | 0.01 |
show binlog events | 8 | 0.1 | 0.01 |
show processlist | 8 | 0.1 | 0.01 |
show engine status | 6 | 0.1 | <0.01 |
flush | 5 | 0.1 | <0.01 |
create db | 1 | <0.1 | <0.01 |