| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 45,165 | 59.4 | 56.76 |
| set option | 9,573 | 12.6 | 12.03 |
| show tables | 5,135 | 6.8 | 6.45 |
| show keys | 4,480 | 5.9 | 5.63 |
| show fields | 3,846 | 5.1 | 4.83 |
| change db | 2,477 | 3.3 | 3.11 |
| insert | 1,846 | 2.4 | 2.32 |
| show variables | 1,542 | 2 | 1.94 |
| begin | 1,090 | 1.4 | 1.37 |
| commit | 1,090 | 1.4 | 1.37 |
| show create table | 1,030 | 1.4 | 1.29 |
| update | 1,006 | 1.3 | 1.26 |
| show grants | 370 | 0.5 | 0.46 |
| show warnings | 211 | 0.3 | 0.27 |
| show storage engines | 210 | 0.3 | 0.26 |
| show binlogs | 136 | 0.2 | 0.17 |
| stmt close | 72 | 0.1 | 0.09 |
| stmt execute | 72 | 0.1 | 0.09 |
| stmt prepare | 72 | 0.1 | 0.09 |
| show slave status | 44 | 0.1 | 0.06 |
| show master status | 41 | 0.1 | 0.05 |
| show table status | 35 | <0.1 | 0.04 |
| show status | 22 | <0.1 | 0.03 |
| show processlist | 3 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |