| Statements | # | ø per hour | % |
|---|---|---|---|
| stmt execute | 160 k | 2,462.4 | 22.06 |
| stmt prepare | 131 k | 2,009.2 | 18.00 |
| stmt close | 131 k | 2,007.1 | 17.98 |
| select | 112 k | 1,714.9 | 15.36 |
| show fields | 79,467 | 1,220.7 | 10.93 |
| insert | 33,751 | 518.5 | 4.64 |
| commit | 22,950 | 352.5 | 3.16 |
| set option | 16,649 | 255.8 | 2.29 |
| show tables | 10,650 | 163.6 | 1.47 |
| show keys | 7,233 | 111.1 | 1.00 |
| create table | 7,217 | 110.9 | 0.99 |
| change db | 4,888 | 75.1 | 0.67 |
| show create table | 3,090 | 47.5 | 0.43 |
| update | 2,158 | 33.1 | 0.30 |
| show variables | 2,104 | 32.3 | 0.29 |
| rollback to savepoint | 924 | 14.2 | 0.13 |
| show grants | 456 | 7 | 0.06 |
| show storage engines | 454 | 7 | 0.06 |
| show warnings | 323 | 5 | 0.04 |
| show table status | 170 | 2.6 | 0.02 |
| show slave status | 119 | 1.8 | 0.02 |
| show master status | 117 | 1.8 | 0.02 |
| show binlogs | 109 | 1.7 | 0.01 |
| show function status | 53 | 0.8 | 0.01 |
| show procedure status | 53 | 0.8 | 0.01 |
| release savepoint | 50 | 0.8 | 0.01 |
| savepoint | 50 | 0.8 | 0.01 |
| show create db | 50 | 0.8 | 0.01 |
| show create trigger | 50 | 0.8 | 0.01 |
| show events | 50 | 0.8 | 0.01 |
| show package status | 50 | 0.8 | 0.01 |
| show package body status | 50 | 0.8 | 0.01 |
| begin | 26 | 0.4 | <0.01 |
| show create func | 21 | 0.3 | <0.01 |
| show status | 8 | 0.1 | <0.01 |
| show databases | 5 | 0.1 | <0.01 |
| unlock tables | 5 | 0.1 | <0.01 |
| create db | 4 | 0.1 | <0.01 |
| empty query | 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 |
| flush | 1 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |