| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 3,870 k | 4,567.5 | 77.52 |
| show tables | 273 k | 321.7 | 5.46 |
| show fields | 248 k | 292.3 | 4.96 |
| change db | 189 k | 223.6 | 3.79 |
| set option | 143 k | 168.4 | 2.86 |
| show keys | 73,245 | 86.4 | 1.47 |
| replace | 43,017 | 50.8 | 0.86 |
| show variables | 28,985 | 34.2 | 0.58 |
| show create table | 28,976 | 34.2 | 0.58 |
| stmt execute | 23,119 | 27.3 | 0.46 |
| stmt prepare | 22,006 | 26 | 0.44 |
| stmt close | 17,901 | 21.1 | 0.36 |
| show storage engines | 10,846 | 12.8 | 0.22 |
| show warnings | 9,677 | 11.4 | 0.19 |
| insert | 2,755 | 3.3 | 0.06 |
| show table status | 2,388 | 2.8 | 0.05 |
| alter table | 2,070 | 2.4 | 0.04 |
| show grants | 1,443 | 1.7 | 0.03 |
| delete | 708 | 0.8 | 0.01 |
| update | 576 | 0.7 | 0.01 |
| show create db | 461 | 0.5 | 0.01 |
| show slave status | 364 | 0.4 | 0.01 |
| show master status | 357 | 0.4 | 0.01 |
| begin | 153 | 0.2 | <0.01 |
| commit | 153 | 0.2 | <0.01 |
| create table | 136 | 0.2 | <0.01 |
| show binlogs | 119 | 0.1 | <0.01 |
| insert select | 91 | 0.1 | <0.01 |
| show create proc | 64 | 0.1 | <0.01 |
| show function status | 56 | 0.1 | <0.01 |
| show procedure status | 56 | 0.1 | <0.01 |
| show status | 46 | 0.1 | <0.01 |
| show triggers | 45 | 0.1 | <0.01 |
| do | 33 | <0.1 | <0.01 |
| lock tables | 22 | <0.1 | <0.01 |
| unlock tables | 22 | <0.1 | <0.01 |
| update multi | 22 | <0.1 | <0.01 |
| show package status | 11 | <0.1 | <0.01 |
| show package body status | 11 | <0.1 | <0.01 |
| show databases | 10 | <0.1 | <0.01 |
| show open tables | 5 | <0.1 | <0.01 |
| show processlist | 5 | <0.1 | <0.01 |
| show collations | 4 | <0.1 | <0.01 |
| show engine status | 3 | <0.1 | <0.01 |
| show charsets | 2 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| drop db | 1 | <0.1 | <0.01 |
| rename table | 1 | <0.1 | <0.01 |