Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 7,313 k | 23.6 k | 52.07 |
| stmt execute | 5,285 k | 17.1 k | 37.63 |
| stmt prepare | 480 k | 1,547.9 | 3.42 |
| stmt close | 479 k | 1,545.4 | 3.41 |
| show tables | 133 k | 430.7 | 0.95 |
| show fields | 102 k | 328.1 | 0.72 |
| change db | 85,753 | 276.7 | 0.61 |
| set option | 72,884 | 235.2 | 0.52 |
| show keys | 34,943 | 112.7 | 0.25 |
| show variables | 13,481 | 43.5 | 0.10 |
| replace | 10,700 | 34.5 | 0.08 |
| show create table | 8,211 | 26.5 | 0.06 |
| update | 7,166 | 23.1 | 0.05 |
| show warnings | 5,200 | 16.8 | 0.04 |
| insert | 4,195 | 13.5 | 0.03 |
| begin | 3,609 | 11.6 | 0.03 |
| commit | 2,924 | 9.4 | 0.02 |
| show storage engines | 1,468 | 4.7 | 0.01 |
| show grants | 810 | 2.6 | 0.01 |
| show binlogs | 720 | 2.3 | 0.01 |
| rollback | 660 | 2.1 | <0.01 |
| show table status | 257 | 0.8 | <0.01 |
| show slave status | 197 | 0.6 | <0.01 |
| show master status | 191 | 0.6 | <0.01 |
| rollback to savepoint | 164 | 0.5 | <0.01 |
| delete | 153 | 0.5 | <0.01 |
| unlock tables | 27 | 0.1 | <0.01 |
| release savepoint | 25 | 0.1 | <0.01 |
| savepoint | 25 | 0.1 | <0.01 |
| show events | 25 | 0.1 | <0.01 |
| show status | 25 | 0.1 | <0.01 |
| create table | 13 | <0.1 | <0.01 |
| alter table | 11 | <0.1 | <0.01 |
| show function status | 8 | <0.1 | <0.01 |
| show procedure status | 8 | <0.1 | <0.01 |
| show package status | 7 | <0.1 | <0.01 |
| show package body status | 7 | <0.1 | <0.01 |
| grant | 5 | <0.1 | <0.01 |
| flush | 4 | <0.1 | <0.01 |
| create db | 3 | <0.1 | <0.01 |
| rename table | 3 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| update multi | 3 | <0.1 | <0.01 |
| create user | 2 | <0.1 | <0.01 |
| lock tables | 2 | <0.1 | <0.01 |
| revoke | 2 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| drop db | 1 | <0.1 | <0.01 |
| drop table | 1 | <0.1 | <0.01 |