| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 2,673 k | 15.7 k | 77.91 |
| show tables | 187 k | 1,098.4 | 5.45 |
| show fields | 175 k | 1,028.2 | 5.10 |
| change db | 133 k | 778.1 | 3.86 |
| set option | 98,049 | 575.6 | 2.86 |
| show keys | 63,266 | 371.4 | 1.84 |
| replace | 31,386 | 184.3 | 0.91 |
| show variables | 27,887 | 163.7 | 0.81 |
| show create table | 21,106 | 123.9 | 0.62 |
| show warnings | 10,834 | 63.6 | 0.32 |
| show storage engines | 4,968 | 29.2 | 0.14 |
| stmt close | 992 | 5.8 | 0.03 |
| stmt execute | 992 | 5.8 | 0.03 |
| stmt prepare | 992 | 5.8 | 0.03 |
| show grants | 646 | 3.8 | 0.02 |
| show table status | 627 | 3.7 | 0.02 |
| delete | 572 | 3.4 | 0.02 |
| show slave status | 402 | 2.4 | 0.01 |
| show master status | 396 | 2.3 | 0.01 |
| show binlogs | 185 | 1.1 | 0.01 |
| show status | 36 | 0.2 | <0.01 |
| show triggers | 21 | 0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show databases | 2 | <0.1 | <0.01 |