| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 18,340 | 685 | 50.18 |
| set option | 5,223 | 195.1 | 14.29 |
| show tables | 4,487 | 167.6 | 12.28 |
| show keys | 2,135 | 79.7 | 5.84 |
| change db | 1,873 | 70 | 5.12 |
| show fields | 1,564 | 58.4 | 4.28 |
| show variables | 1,099 | 41 | 3.01 |
| show create table | 313 | 11.7 | 0.86 |
| show grants | 263 | 9.8 | 0.72 |
| stmt close | 206 | 7.7 | 0.56 |
| stmt execute | 206 | 7.7 | 0.56 |
| stmt prepare | 206 | 7.7 | 0.56 |
| show storage engines | 197 | 7.4 | 0.54 |
| show binlogs | 110 | 4.1 | 0.30 |
| show slave status | 66 | 2.5 | 0.18 |
| show master status | 63 | 2.4 | 0.17 |
| show warnings | 49 | 1.8 | 0.13 |
| create table | 45 | 1.7 | 0.12 |
| show table status | 43 | 1.6 | 0.12 |
| update | 33 | 1.2 | 0.09 |
| show status | 15 | 0.6 | 0.04 |
| insert | 6 | 0.2 | 0.02 |
| create db | 2 | 0.1 | 0.01 |
| show processlist | 2 | 0.1 | 0.01 |
| drop table | 1 | <0.1 | <0.01 |
| empty query | 1 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |