| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 2,513 k | 4,444.5 | 75.75 |
| show fields | 156 k | 275.4 | 4.69 |
| show tables | 145 k | 256.4 | 4.37 |
| change db | 111 k | 196.8 | 3.35 |
| set option | 89,949 | 159.1 | 2.71 |
| stmt close | 56,253 | 99.5 | 1.70 |
| stmt execute | 56,253 | 99.5 | 1.70 |
| stmt prepare | 56,253 | 99.5 | 1.70 |
| show keys | 34,641 | 61.3 | 1.04 |
| show variables | 31,043 | 54.9 | 0.94 |
| replace | 22,271 | 39.4 | 0.67 |
| show create table | 20,376 | 36 | 0.61 |
| show warnings | 13,419 | 23.7 | 0.40 |
| insert | 4,600 | 8.1 | 0.14 |
| show storage engines | 3,148 | 5.6 | 0.09 |
| show grants | 943 | 1.7 | 0.03 |
| update | 923 | 1.6 | 0.03 |
| show table status | 882 | 1.6 | 0.03 |
| show binlogs | 345 | 0.6 | 0.01 |
| insert select | 323 | 0.6 | 0.01 |
| delete | 299 | 0.5 | 0.01 |
| rollback to savepoint | 180 | 0.3 | 0.01 |
| show slave status | 124 | 0.2 | <0.01 |
| show master status | 117 | 0.2 | <0.01 |
| show status | 39 | 0.1 | <0.01 |
| create table | 15 | <0.1 | <0.01 |
| alter table | 14 | <0.1 | <0.01 |
| show create proc | 14 | <0.1 | <0.01 |
| show databases | 11 | <0.1 | <0.01 |
| drop procedure | 8 | <0.1 | <0.01 |
| show procedure status | 8 | <0.1 | <0.01 |
| truncate | 8 | <0.1 | <0.01 |
| create procedure | 7 | <0.1 | <0.01 |
| drop table | 7 | <0.1 | <0.01 |
| show function status | 6 | <0.1 | <0.01 |
| create temporary table | 5 | <0.1 | <0.01 |
| drop temporary table | 5 | <0.1 | <0.01 |
| call procedure | 4 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show charsets | 2 | <0.1 | <0.01 |
| show collations | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| begin | 1 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| release savepoint | 1 | <0.1 | <0.01 |
| savepoint | 1 | <0.1 | <0.01 |
| show package status | 1 | <0.1 | <0.01 |
| show package body status | 1 | <0.1 | <0.01 |
| unlock tables | 1 | <0.1 | <0.01 |