Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 2,603 k | 13 k | 33.41 |
| stmt execute | 1,092 k | 5,452.1 | 14.02 |
| stmt prepare | 1,084 k | 5,411.1 | 13.91 |
| stmt close | 1,068 k | 5,330.3 | 13.70 |
| show fields | 587 k | 2,932.6 | 7.54 |
| set option | 540 k | 2,696 | 6.93 |
| insert | 267 k | 1,332.4 | 3.43 |
| show tables | 158 k | 790.2 | 2.03 |
| show keys | 116 k | 577.2 | 1.48 |
| change db | 83,377 | 416.2 | 1.07 |
| create table | 74,457 | 371.7 | 0.96 |
| update | 43,017 | 214.8 | 0.55 |
| show variables | 20,908 | 104.4 | 0.27 |
| replace | 18,469 | 92.2 | 0.24 |
| show create table | 15,639 | 78.1 | 0.20 |
| show warnings | 8,767 | 43.8 | 0.11 |
| show storage engines | 2,835 | 14.2 | 0.04 |
| begin | 2,431 | 12.1 | 0.03 |
| commit | 2,418 | 12.1 | 0.03 |
| update multi | 835 | 4.2 | 0.01 |
| rollback to savepoint | 736 | 3.7 | 0.01 |
| delete | 470 | 2.3 | 0.01 |
| show table status | 317 | 1.6 | <0.01 |
| show grants | 309 | 1.5 | <0.01 |
| show slave status | 175 | 0.9 | <0.01 |
| show master status | 168 | 0.8 | <0.01 |
| show binlogs | 153 | 0.8 | <0.01 |
| alter table | 133 | 0.7 | <0.01 |
| show status | 41 | 0.2 | <0.01 |
| show create proc | 20 | 0.1 | <0.01 |
| release savepoint | 8 | <0.1 | <0.01 |
| savepoint | 8 | <0.1 | <0.01 |
| show function status | 8 | <0.1 | <0.01 |
| show package status | 8 | <0.1 | <0.01 |
| show package body status | 8 | <0.1 | <0.01 |
| show procedure status | 8 | <0.1 | <0.01 |
| unlock tables | 8 | <0.1 | <0.01 |
| show processlist | 6 | <0.1 | <0.01 |
| rollback | 5 | <0.1 | <0.01 |
| show engine status | 4 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |