| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,049 k | 113.6 k | 77.15 |
| show tables | 71,939 | 7,786.8 | 5.29 |
| show fields | 69,346 | 7,506.1 | 5.10 |
| change db | 51,609 | 5,586.2 | 3.79 |
| set option | 39,522 | 4,277.9 | 2.91 |
| show keys | 36,773 | 3,980.4 | 2.70 |
| show variables | 12,892 | 1,395.4 | 0.95 |
| replace | 11,232 | 1,215.8 | 0.83 |
| show create table | 8,305 | 898.9 | 0.61 |
| show warnings | 5,331 | 577 | 0.39 |
| show storage engines | 1,362 | 147.4 | 0.10 |
| show grants | 498 | 53.9 | 0.04 |
| stmt close | 369 | 39.9 | 0.03 |
| stmt execute | 369 | 39.9 | 0.03 |
| stmt prepare | 369 | 39.9 | 0.03 |
| update | 197 | 21.3 | 0.01 |
| show binlogs | 166 | 18 | 0.01 |
| show table status | 138 | 14.9 | 0.01 |
| show slave status | 126 | 13.6 | 0.01 |
| show master status | 121 | 13.1 | 0.01 |
| insert | 79 | 8.6 | 0.01 |
| delete | 52 | 5.6 | <0.01 |
| show status | 34 | 3.7 | <0.01 |
| show engine status | 4 | 0.4 | <0.01 |
| flush | 3 | 0.3 | <0.01 |
| show processlist | 3 | 0.3 | <0.01 |