| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 29,465 | 1,065.2 | 49.39 |
| set option | 7,719 | 279.1 | 12.94 |
| show tables | 7,067 | 255.5 | 11.85 |
| show keys | 3,984 | 144 | 6.68 |
| show fields | 3,501 | 126.6 | 5.87 |
| change db | 3,049 | 110.2 | 5.11 |
| show variables | 1,784 | 64.5 | 2.99 |
| show create table | 746 | 27 | 1.25 |
| show grants | 635 | 23 | 1.06 |
| show warnings | 272 | 9.8 | 0.46 |
| show storage engines | 249 | 9 | 0.42 |
| stmt close | 224 | 8.1 | 0.38 |
| stmt execute | 224 | 8.1 | 0.38 |
| stmt prepare | 224 | 8.1 | 0.38 |
| show binlogs | 178 | 6.4 | 0.30 |
| show slave status | 77 | 2.8 | 0.13 |
| show master status | 74 | 2.7 | 0.12 |
| show table status | 55 | 2 | 0.09 |
| create table | 45 | 1.6 | 0.08 |
| update | 33 | 1.2 | 0.06 |
| show status | 28 | 1 | 0.05 |
| insert | 6 | 0.2 | 0.01 |
| show processlist | 4 | 0.1 | 0.01 |
| create db | 2 | 0.1 | <0.01 |
| flush | 2 | 0.1 | <0.01 |
| show engine status | 2 | 0.1 | <0.01 |
| drop table | 1 | <0.1 | <0.01 |
| empty query | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |