| Statements | # | ø per hour | % |
|---|---|---|---|
| stmt execute | 234 k | 2,607.8 | 21.35 |
| stmt prepare | 201 k | 2,240.4 | 18.34 |
| stmt close | 201 k | 2,238.6 | 18.33 |
| select | 176 k | 1,957.2 | 16.03 |
| show fields | 121 k | 1,343.6 | 11.00 |
| commit | 39,201 | 436.6 | 3.57 |
| insert | 37,637 | 419.2 | 3.43 |
| set option | 25,100 | 279.5 | 2.29 |
| show tables | 16,916 | 188.4 | 1.54 |
| show keys | 12,202 | 135.9 | 1.11 |
| change db | 8,145 | 90.7 | 0.74 |
| create table | 8,074 | 89.9 | 0.74 |
| show create table | 4,882 | 54.4 | 0.45 |
| show variables | 3,805 | 42.4 | 0.35 |
| update | 2,320 | 25.8 | 0.21 |
| show grants | 1,422 | 15.8 | 0.13 |
| rollback to savepoint | 1,294 | 14.4 | 0.12 |
| show warnings | 791 | 8.8 | 0.07 |
| show storage engines | 604 | 6.7 | 0.06 |
| show table status | 260 | 2.9 | 0.02 |
| show binlogs | 204 | 2.3 | 0.02 |
| show slave status | 136 | 1.5 | 0.01 |
| show master status | 133 | 1.5 | 0.01 |
| show function status | 73 | 0.8 | 0.01 |
| show procedure status | 73 | 0.8 | 0.01 |
| release savepoint | 70 | 0.8 | 0.01 |
| savepoint | 70 | 0.8 | 0.01 |
| show create db | 70 | 0.8 | 0.01 |
| show create trigger | 70 | 0.8 | 0.01 |
| show events | 70 | 0.8 | 0.01 |
| show package status | 70 | 0.8 | 0.01 |
| show package body status | 70 | 0.8 | 0.01 |
| begin | 33 | 0.4 | <0.01 |
| show create func | 30 | 0.3 | <0.01 |
| show status | 26 | 0.3 | <0.01 |
| show databases | 7 | 0.1 | <0.01 |
| unlock tables | 7 | 0.1 | <0.01 |
| create db | 4 | <0.1 | <0.01 |
| empty query | 3 | <0.1 | <0.01 |
| flush | 3 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| delete | 2 | <0.1 | <0.01 |
| alter db | 1 | <0.1 | <0.01 |
| alter table | 1 | <0.1 | <0.01 |