| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 81,247 | 57.2 k | 69.98 |
| show fields | 5,375 | 3,785.2 | 4.63 |
| show tables | 5,364 | 3,777.5 | 4.62 |
| change db | 4,477 | 3,152.8 | 3.86 |
| stmt close | 3,809 | 2,682.4 | 3.28 |
| stmt execute | 3,809 | 2,682.4 | 3.28 |
| stmt prepare | 3,809 | 2,682.4 | 3.28 |
| set option | 3,299 | 2,323.2 | 2.84 |
| create table | 1,599 | 1,126.1 | 1.38 |
| show keys | 1,059 | 745.8 | 0.91 |
| show variables | 833 | 586.6 | 0.72 |
| insert | 601 | 423.2 | 0.52 |
| replace | 196 | 138 | 0.17 |
| drop table | 178 | 125.4 | 0.15 |
| show create table | 137 | 96.5 | 0.12 |
| show storage engines | 132 | 93 | 0.11 |
| show slave status | 36 | 25.4 | 0.03 |
| show master status | 33 | 23.2 | 0.03 |
| show grants | 22 | 15.5 | 0.02 |
| truncate | 22 | 15.5 | 0.02 |
| show binlogs | 21 | 14.8 | 0.02 |
| update | 20 | 14.1 | 0.02 |
| show table status | 15 | 10.6 | 0.01 |
| show status | 9 | 6.3 | 0.01 |
| create db | 3 | 2.1 | <0.01 |
| show databases | 2 | 1.4 | <0.01 |
| show processlist | 1 | 0.7 | <0.01 |