| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 22,840 | 254.2 | 44.25 |
| set option | 5,751 | 64 | 11.14 |
| show tables | 4,607 | 51.3 | 8.93 |
| stmt execute | 2,823 | 31.4 | 5.47 |
| stmt prepare | 2,823 | 31.4 | 5.47 |
| show keys | 2,714 | 30.2 | 5.26 |
| stmt close | 2,524 | 28.1 | 4.89 |
| change db | 2,292 | 25.5 | 4.44 |
| show fields | 2,057 | 22.9 | 3.99 |
| show variables | 1,272 | 14.2 | 2.46 |
| show create table | 524 | 5.8 | 1.02 |
| show grants | 431 | 4.8 | 0.84 |
| show binlogs | 263 | 2.9 | 0.51 |
| show storage engines | 174 | 1.9 | 0.34 |
| insert | 166 | 1.8 | 0.32 |
| show warnings | 113 | 1.3 | 0.22 |
| show slave status | 74 | 0.8 | 0.14 |
| show master status | 68 | 0.8 | 0.13 |
| show table status | 66 | 0.7 | 0.13 |
| show status | 20 | 0.2 | 0.04 |
| show create proc | 4 | <0.1 | 0.01 |
| show create func | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |