| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 13,825 k | 732.1 k | 78.03 |
| show fields | 815 k | 43.1 k | 4.60 |
| show tables | 682 k | 36.1 k | 3.85 |
| show keys | 675 k | 35.7 k | 3.81 |
| change db | 546 k | 28.9 k | 3.08 |
| set option | 411 k | 21.8 k | 2.32 |
| show variables | 270 k | 14.3 k | 1.53 |
| show create table | 135 k | 7,149.9 | 0.76 |
| show grants | 135 k | 7,147 | 0.76 |
| show warnings | 135 k | 7,131.6 | 0.76 |
| replace | 72,298 | 3,828.3 | 0.41 |
| insert | 10,018 | 530.5 | 0.06 |
| update | 2,066 | 109.4 | 0.01 |
| stmt close | 1,131 | 59.9 | 0.01 |
| stmt execute | 1,131 | 59.9 | 0.01 |
| stmt prepare | 1,131 | 59.9 | 0.01 |
| delete | 492 | 26.1 | <0.01 |
| show storage engines | 165 | 8.7 | <0.01 |
| show binlogs | 155 | 8.2 | <0.01 |
| show slave status | 67 | 3.5 | <0.01 |
| show master status | 64 | 3.4 | <0.01 |
| show table status | 56 | 3 | <0.01 |
| show status | 15 | 0.8 | <0.01 |
| show function status | 8 | 0.4 | <0.01 |
| show procedure status | 8 | 0.4 | <0.01 |
| update multi | 6 | 0.3 | <0.01 |
| begin | 4 | 0.2 | <0.01 |
| commit | 4 | 0.2 | <0.01 |
| alter table | 3 | 0.2 | <0.01 |
| create temporary table | 3 | 0.2 | <0.01 |
| drop temporary table | 3 | 0.2 | <0.01 |
| create table | 2 | 0.1 | <0.01 |
| flush | 1 | 0.1 | <0.01 |
| show engine status | 1 | 0.1 | <0.01 |
| show processlist | 1 | 0.1 | <0.01 |