| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,632 k | 20.5 k | 58.83 |
| change db | 907 k | 11.4 k | 32.68 |
| insert | 86,700 | 1,091 | 3.12 |
| set option | 81,209 | 1,021.9 | 2.93 |
| show fields | 14,883 | 187.3 | 0.54 |
| show tables | 14,448 | 181.8 | 0.52 |
| show keys | 14,331 | 180.3 | 0.52 |
| update | 6,010 | 75.6 | 0.22 |
| delete | 5,357 | 67.4 | 0.19 |
| show variables | 4,002 | 50.4 | 0.14 |
| show create table | 3,388 | 42.6 | 0.12 |
| commit | 2,394 | 30.1 | 0.09 |
| show warnings | 769 | 9.7 | 0.03 |
| show storage engines | 718 | 9 | 0.03 |
| show table status | 607 | 7.6 | 0.02 |
| show grants | 400 | 5 | 0.01 |
| show binlogs | 132 | 1.7 | <0.01 |
| rollback | 63 | 0.8 | <0.01 |
| stmt close | 60 | 0.8 | <0.01 |
| stmt execute | 60 | 0.8 | <0.01 |
| stmt prepare | 60 | 0.8 | <0.01 |
| show slave status | 42 | 0.5 | <0.01 |
| show master status | 39 | 0.5 | <0.01 |
| show status | 19 | 0.2 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |