| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 23,380 | 870.7 | 50.56 |
| set option | 6,249 | 232.7 | 13.51 |
| show tables | 5,479 | 204.1 | 11.85 |
| show keys | 2,843 | 105.9 | 6.15 |
| show fields | 2,315 | 86.2 | 5.01 |
| change db | 2,302 | 85.7 | 4.98 |
| show variables | 1,424 | 53 | 3.08 |
| show create table | 492 | 18.3 | 1.06 |
| show grants | 337 | 12.6 | 0.73 |
| show storage engines | 223 | 8.3 | 0.48 |
| stmt close | 206 | 7.7 | 0.45 |
| stmt execute | 206 | 7.7 | 0.45 |
| stmt prepare | 206 | 7.7 | 0.45 |
| show warnings | 148 | 5.5 | 0.32 |
| show binlogs | 125 | 4.7 | 0.27 |
| show slave status | 72 | 2.7 | 0.16 |
| show master status | 69 | 2.6 | 0.15 |
| show table status | 48 | 1.8 | 0.10 |
| create table | 45 | 1.7 | 0.10 |
| update | 33 | 1.2 | 0.07 |
| show status | 22 | 0.8 | 0.05 |
| insert | 6 | 0.2 | 0.01 |
| show processlist | 3 | 0.1 | 0.01 |
| create db | 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 engine status | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |