| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 65,849 | 7,974.4 | 51.62 |
| set option | 14,776 | 1,789.4 | 11.58 |
| show tables | 13,215 | 1,600.4 | 10.36 |
| show fields | 9,818 | 1,189 | 7.70 |
| show keys | 8,400 | 1,017.3 | 6.59 |
| change db | 5,845 | 707.8 | 4.58 |
| show variables | 2,884 | 349.3 | 2.26 |
| show create table | 2,485 | 300.9 | 1.95 |
| stmt execute | 810 | 98.1 | 0.64 |
| stmt close | 800 | 96.9 | 0.63 |
| stmt prepare | 800 | 96.9 | 0.63 |
| show storage engines | 746 | 90.3 | 0.58 |
| show table status | 348 | 42.1 | 0.27 |
| show warnings | 336 | 40.7 | 0.26 |
| show slave status | 111 | 13.4 | 0.09 |
| show master status | 108 | 13.1 | 0.08 |
| insert | 81 | 9.8 | 0.06 |
| show grants | 64 | 7.8 | 0.05 |
| update | 27 | 3.3 | 0.02 |
| show binlogs | 23 | 2.8 | 0.02 |
| show status | 16 | 1.9 | 0.01 |
| begin | 5 | 0.6 | <0.01 |
| commit | 5 | 0.6 | <0.01 |
| alter table | 2 | 0.2 | <0.01 |
| show processlist | 2 | 0.2 | <0.01 |
| flush | 1 | 0.1 | <0.01 |
| show engine status | 1 | 0.1 | <0.01 |