| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 178 k | 300.5 | 59.94 |
| show tables | 30,354 | 51.4 | 10.25 |
| set option | 21,973 | 37.2 | 7.42 |
| show keys | 20,919 | 35.4 | 7.06 |
| show fields | 19,052 | 32.2 | 6.43 |
| change db | 7,850 | 13.3 | 2.65 |
| show variables | 6,254 | 10.6 | 2.11 |
| show grants | 4,072 | 6.9 | 1.37 |
| show create table | 3,545 | 6 | 1.20 |
| show warnings | 1,833 | 3.1 | 0.62 |
| show storage engines | 908 | 1.5 | 0.31 |
| show binlogs | 720 | 1.2 | 0.24 |
| stmt execute | 180 | 0.3 | 0.06 |
| stmt close | 180 | 0.3 | 0.06 |
| stmt prepare | 180 | 0.3 | 0.06 |
| show master status | 136 | 0.2 | 0.05 |
| show replica status | 136 | 0.2 | 0.05 |
| show slave status | 136 | 0.2 | 0.05 |
| show table status | 79 | 0.1 | 0.03 |
| show status | 65 | 0.1 | 0.02 |
| create table | 35 | 0.1 | 0.01 |
| show binlog events | 12 | <0.1 | <0.01 |
| show processlist | 9 | <0.1 | <0.01 |
| show replicas | 9 | <0.1 | <0.01 |
| show slave hosts | 9 | <0.1 | <0.01 |
| flush | 8 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |