| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 171 k | 3,720.3 | 52.31 |
| set option | 33,356 | 725.4 | 10.20 |
| show keys | 32,130 | 698.8 | 9.83 |
| show fields | 27,315 | 594 | 8.35 |
| show tables | 26,710 | 580.9 | 8.17 |
| show variables | 11,337 | 246.6 | 3.47 |
| change db | 10,109 | 219.8 | 3.09 |
| show create table | 7,423 | 161.4 | 2.27 |
| show warnings | 4,813 | 104.7 | 1.47 |
| show storage engines | 1,523 | 33.1 | 0.47 |
| show slave status | 206 | 4.5 | 0.06 |
| show table status | 202 | 4.4 | 0.06 |
| show master status | 200 | 4.3 | 0.06 |
| insert | 119 | 2.6 | 0.04 |
| update | 81 | 1.8 | 0.02 |
| stmt close | 71 | 1.5 | 0.02 |
| stmt execute | 71 | 1.5 | 0.02 |
| stmt prepare | 71 | 1.5 | 0.02 |
| show grants | 51 | 1.1 | 0.02 |
| begin | 43 | 0.9 | 0.01 |
| commit | 43 | 0.9 | 0.01 |
| show binlogs | 35 | 0.8 | 0.01 |
| show status | 25 | 0.5 | 0.01 |
| create table | 7 | 0.2 | <0.01 |
| show processlist | 3 | 0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |