| Statements | # | ø per hour | % |
|---|---|---|---|
| set option | 83,655 k | 55.2 k | 61.63 |
| select | 29,276 k | 19.3 k | 21.57 |
| commit | 20,717 k | 13.7 k | 15.26 |
| update | 1,103 k | 727.3 | 0.81 |
| show variables | 148 k | 97.6 | 0.11 |
| show tables | 126 k | 83 | 0.09 |
| show collations | 120 k | 79 | 0.09 |
| change db | 113 k | 74.4 | 0.08 |
| show fields | 90,190 | 59.5 | 0.07 |
| show keys | 81,957 | 54.1 | 0.06 |
| insert | 76,179 | 50.2 | 0.06 |
| stmt prepare | 49,249 | 32.5 | 0.04 |
| stmt close | 49,247 | 32.5 | 0.04 |
| stmt execute | 49,247 | 32.5 | 0.04 |
| show grants | 24,627 | 16.2 | 0.02 |
| show create table | 19,985 | 13.2 | 0.01 |
| delete | 13,059 | 8.6 | 0.01 |
| insert select | 13,043 | 8.6 | 0.01 |
| show warnings | 6,946 | 4.6 | 0.01 |
| show storage engines | 3,617 | 2.4 | <0.01 |
| show binlogs | 3,450 | 2.3 | <0.01 |
| show table status | 967 | 0.6 | <0.01 |
| show slave status | 262 | 0.2 | <0.01 |
| show master status | 245 | 0.2 | <0.01 |
| show status | 150 | 0.1 | <0.01 |
| show charsets | 27 | <0.1 | <0.01 |
| show processlist | 17 | <0.1 | <0.01 |
| show databases | 12 | <0.1 | <0.01 |
| show function status | 12 | <0.1 | <0.01 |
| show procedure status | 12 | <0.1 | <0.01 |
| show engine status | 10 | <0.1 | <0.01 |
| flush | 7 | <0.1 | <0.01 |
| create table | 2 | <0.1 | <0.01 |
| stmt reset | 2 | <0.1 | <0.01 |
| truncate | 2 | <0.1 | <0.01 |
| rollback | 1 | <0.1 | <0.01 |
| show triggers | 1 | <0.1 | <0.01 |