| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 754 k | 34 k | 60.26 |
| set option | 159 k | 7,170.8 | 12.73 |
| change db | 75,356 | 3,391.9 | 6.02 |
| show fields | 67,462 | 3,036.6 | 5.39 |
| show tables | 41,712 | 1,877.5 | 3.33 |
| show create table | 38,925 | 1,752.1 | 3.11 |
| show table status | 28,547 | 1,285 | 2.28 |
| show triggers | 28,267 | 1,272.3 | 2.26 |
| show keys | 20,527 | 924 | 1.64 |
| insert | 13,496 | 607.5 | 1.08 |
| delete | 5,456 | 245.6 | 0.44 |
| show variables | 5,222 | 235.1 | 0.42 |
| replace | 5,071 | 228.3 | 0.41 |
| show grants | 2,659 | 119.7 | 0.21 |
| update | 2,046 | 92.1 | 0.16 |
| show storage engines | 1,483 | 66.8 | 0.12 |
| show warnings | 861 | 38.8 | 0.07 |
| commit | 440 | 19.8 | 0.04 |
| stmt close | 77 | 3.5 | 0.01 |
| stmt execute | 77 | 3.5 | 0.01 |
| stmt prepare | 77 | 3.5 | 0.01 |
| create table | 74 | 3.3 | 0.01 |
| show binlogs | 50 | 2.3 | <0.01 |
| show slave status | 44 | 2 | <0.01 |
| show master status | 41 | 1.8 | <0.01 |
| show collations | 23 | 1 | <0.01 |
| show status | 18 | 0.8 | <0.01 |
| truncate | 14 | 0.6 | <0.01 |
| rollback | 3 | 0.1 | <0.01 |
| show processlist | 3 | 0.1 | <0.01 |
| show engine status | 2 | 0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |