| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 15,265 | 171.3 | 41.73 |
| set option | 3,994 | 44.8 | 10.92 |
| show tables | 3,004 | 33.7 | 8.21 |
| stmt execute | 2,801 | 31.4 | 7.66 |
| stmt prepare | 2,801 | 31.4 | 7.66 |
| stmt close | 2,502 | 28.1 | 6.84 |
| show keys | 1,626 | 18.2 | 4.45 |
| change db | 1,501 | 16.8 | 4.10 |
| show fields | 992 | 11.1 | 2.71 |
| show variables | 840 | 9.4 | 2.30 |
| show grants | 295 | 3.3 | 0.81 |
| show create table | 223 | 2.5 | 0.61 |
| show binlogs | 205 | 2.3 | 0.56 |
| insert | 166 | 1.9 | 0.45 |
| show storage engines | 132 | 1.5 | 0.36 |
| show slave status | 67 | 0.8 | 0.18 |
| show master status | 61 | 0.7 | 0.17 |
| show table status | 61 | 0.7 | 0.17 |
| show warnings | 23 | 0.3 | 0.06 |
| show status | 16 | 0.2 | 0.04 |
| show create proc | 2 | <0.1 | 0.01 |
| flush | 1 | <0.1 | <0.01 |
| show create func | 1 | <0.1 | <0.01 |
| show processlist | 1 | <0.1 | <0.01 |