| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 3,959 k | 1,001.6 k | 88.48 |
| show fields | 109 k | 27.6 k | 2.44 |
| show tables | 100 k | 25.4 k | 2.25 |
| show keys | 80,097 | 20.3 k | 1.79 |
| change db | 77,004 | 19.5 k | 1.72 |
| set option | 56,737 | 14.4 k | 1.27 |
| show variables | 30,610 | 7,744.5 | 0.68 |
| show grants | 18,081 | 4,574.6 | 0.40 |
| show create table | 15,715 | 3,976 | 0.35 |
| show warnings | 14,587 | 3,690.6 | 0.33 |
| replace | 6,683 | 1,690.8 | 0.15 |
| show create proc | 1,970 | 498.4 | 0.04 |
| show create func | 1,671 | 422.8 | 0.04 |
| show storage engines | 819 | 207.2 | 0.02 |
| show binlogs | 613 | 155.1 | 0.01 |
| create table | 549 | 138.9 | 0.01 |
| stmt close | 171 | 43.3 | <0.01 |
| stmt execute | 171 | 43.3 | <0.01 |
| stmt prepare | 171 | 43.3 | <0.01 |
| show slave status | 81 | 20.5 | <0.01 |
| show table status | 81 | 20.5 | <0.01 |
| show binlog status | 74 | 18.7 | <0.01 |
| insert | 52 | 13.2 | <0.01 |
| delete | 47 | 11.9 | <0.01 |
| show status | 29 | 7.3 | <0.01 |
| update | 4 | 1 | <0.01 |
| show processlist | 3 | 0.8 | <0.01 |
| flush | 1 | 0.3 | <0.01 |
| show engine status | 1 | 0.3 | <0.01 |