| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 15,326 k | 739.9 k | 78.03 |
| show fields | 904 k | 43.6 k | 4.60 |
| show tables | 762 k | 36.8 k | 3.88 |
| show keys | 745 k | 35.9 k | 3.79 |
| change db | 607 k | 29.3 k | 3.09 |
| set option | 456 k | 22 k | 2.32 |
| show variables | 298 k | 14.4 k | 1.52 |
| show create table | 149 k | 7,194.3 | 0.76 |
| show grants | 149 k | 7,173.8 | 0.76 |
| show warnings | 148 k | 7,155 | 0.75 |
| replace | 80,699 | 3,895.9 | 0.41 |
| insert | 10,018 | 483.6 | 0.05 |
| update | 2,066 | 99.7 | 0.01 |
| stmt close | 1,203 | 58.1 | 0.01 |
| stmt execute | 1,203 | 58.1 | 0.01 |
| stmt prepare | 1,203 | 58.1 | 0.01 |
| delete | 492 | 23.8 | <0.01 |
| show storage engines | 325 | 15.7 | <0.01 |
| show binlogs | 274 | 13.2 | <0.01 |
| show table status | 123 | 5.9 | <0.01 |
| show slave status | 79 | 3.8 | <0.01 |
| show master status | 75 | 3.6 | <0.01 |
| show status | 29 | 1.4 | <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 |
| show engine status | 4 | 0.2 | <0.01 |
| show processlist | 4 | 0.2 | <0.01 |
| alter table | 3 | 0.1 | <0.01 |
| create temporary table | 3 | 0.1 | <0.01 |
| drop temporary table | 3 | 0.1 | <0.01 |
| create table | 2 | 0.1 | <0.01 |
| flush | 2 | 0.1 | <0.01 |