| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 2,421 k | 23.4 k | 46.10 |
| set option | 2,398 k | 23.1 k | 45.66 |
| show tables | 117 k | 1,133 | 2.24 |
| show fields | 101 k | 972.2 | 1.92 |
| change db | 84,050 | 811.1 | 1.60 |
| commit | 34,353 | 331.5 | 0.65 |
| show keys | 29,701 | 286.6 | 0.57 |
| replace | 14,494 | 139.9 | 0.28 |
| show variables | 12,968 | 125.1 | 0.25 |
| update | 12,074 | 116.5 | 0.23 |
| show create table | 10,683 | 103.1 | 0.20 |
| insert | 4,527 | 43.7 | 0.09 |
| show storage engines | 3,471 | 33.5 | 0.07 |
| show warnings | 2,783 | 26.9 | 0.05 |
| show table status | 2,019 | 19.5 | 0.04 |
| stmt close | 503 | 4.9 | 0.01 |
| stmt execute | 503 | 4.9 | 0.01 |
| stmt prepare | 503 | 4.9 | 0.01 |
| show grants | 376 | 3.6 | 0.01 |
| show create proc | 359 | 3.5 | 0.01 |
| show slave status | 215 | 2.1 | <0.01 |
| show master status | 212 | 2 | <0.01 |
| show triggers | 116 | 1.1 | <0.01 |
| show binlogs | 69 | 0.7 | <0.01 |
| show collations | 51 | 0.5 | <0.01 |
| call procedure | 39 | 0.4 | <0.01 |
| delete | 37 | 0.4 | <0.01 |
| release savepoint | 34 | 0.3 | <0.01 |
| savepoint | 34 | 0.3 | <0.01 |
| show status | 24 | 0.2 | <0.01 |
| kill | 15 | 0.1 | <0.01 |
| show create trigger | 15 | 0.1 | <0.01 |
| show create func | 14 | 0.1 | <0.01 |
| show databases | 14 | 0.1 | <0.01 |
| show function status | 12 | 0.1 | <0.01 |
| show procedure status | 12 | 0.1 | <0.01 |
| empty query | 6 | 0.1 | <0.01 |
| show create db | 6 | 0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| alter table | 3 | <0.1 | <0.01 |
| insert select | 3 | <0.1 | <0.01 |
| create table | 2 | <0.1 | <0.01 |
| drop temporary table | 2 | <0.1 | <0.01 |
| create temporary table | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |
| show open tables | 1 | <0.1 | <0.01 |