Statements | # | ø per hour | % |
---|---|---|---|
select | 55,531 | 934.3 | 61.45 |
show tables | 8,706 | 146.5 | 9.63 |
show keys | 6,818 | 114.7 | 7.54 |
set option | 6,138 | 103.3 | 6.79 |
show fields | 5,966 | 100.4 | 6.60 |
change db | 2,194 | 36.9 | 2.43 |
show variables | 1,655 | 27.8 | 1.83 |
show create table | 992 | 16.7 | 1.10 |
show grants | 909 | 15.3 | 1.01 |
show warnings | 486 | 8.2 | 0.54 |
show storage engines | 317 | 5.3 | 0.35 |
show binlogs | 196 | 3.3 | 0.22 |
show master status | 67 | 1.1 | 0.07 |
show replica status | 67 | 1.1 | 0.07 |
show slave status | 67 | 1.1 | 0.07 |
stmt execute | 48 | 0.8 | 0.05 |
stmt close | 48 | 0.8 | 0.05 |
stmt prepare | 48 | 0.8 | 0.05 |
create table | 35 | 0.6 | 0.04 |
show status | 33 | 0.6 | 0.04 |
show table status | 17 | 0.3 | 0.02 |
show replicas | 6 | 0.1 | 0.01 |
show slave hosts | 6 | 0.1 | 0.01 |
show binlog events | 5 | 0.1 | 0.01 |
show engine status | 4 | 0.1 | <0.01 |
show processlist | 4 | 0.1 | <0.01 |
flush | 3 | 0.1 | <0.01 |
create db | 1 | <0.1 | <0.01 |