| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 296 k | 102.7 k | 78.45 |
| show tables | 22,660 | 7,870.3 | 6.01 |
| show fields | 16,970 | 5,894.1 | 4.50 |
| change db | 15,595 | 5,416.5 | 4.14 |
| set option | 11,099 | 3,854.9 | 2.95 |
| show keys | 6,086 | 2,113.8 | 1.62 |
| show variables | 2,817 | 978.4 | 0.75 |
| replace | 2,083 | 723.5 | 0.55 |
| show create table | 1,200 | 416.8 | 0.32 |
| show warnings | 546 | 189.6 | 0.14 |
| show grants | 531 | 184.4 | 0.14 |
| show storage engines | 404 | 140.3 | 0.11 |
| stmt execute | 218 | 75.7 | 0.06 |
| stmt prepare | 218 | 75.7 | 0.06 |
| show binlogs | 197 | 68.4 | 0.05 |
| stmt close | 130 | 45.2 | 0.03 |
| show table status | 122 | 42.4 | 0.03 |
| show slave status | 105 | 36.5 | 0.03 |
| show master status | 99 | 34.4 | 0.03 |
| update | 59 | 20.5 | 0.02 |
| show status | 33 | 11.5 | 0.01 |
| insert | 13 | 4.5 | <0.01 |
| create table | 6 | 2.1 | <0.01 |
| show processlist | 5 | 1.7 | <0.01 |
| show engine status | 3 | 1 | <0.01 |
| alter table | 1 | 0.3 | <0.01 |
| create db | 1 | 0.3 | <0.01 |