| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,102 k | 37.7 k | 77.34 |
| show tables | 76,032 | 2,600.3 | 5.33 |
| show fields | 71,294 | 2,438.3 | 5.00 |
| change db | 54,833 | 1,875.3 | 3.85 |
| set option | 43,448 | 1,485.9 | 3.05 |
| show keys | 35,234 | 1,205 | 2.47 |
| show variables | 12,574 | 430 | 0.88 |
| replace | 11,312 | 386.9 | 0.79 |
| show create table | 8,350 | 285.6 | 0.59 |
| show warnings | 5,069 | 173.4 | 0.36 |
| show storage engines | 1,608 | 55 | 0.11 |
| show grants | 624 | 21.3 | 0.04 |
| stmt close | 426 | 14.6 | 0.03 |
| stmt execute | 426 | 14.6 | 0.03 |
| stmt prepare | 426 | 14.6 | 0.03 |
| show binlogs | 245 | 8.4 | 0.02 |
| insert | 213 | 7.3 | 0.01 |
| show table status | 175 | 6 | 0.01 |
| show slave status | 162 | 5.5 | 0.01 |
| show master status | 156 | 5.3 | 0.01 |
| update | 105 | 3.6 | 0.01 |
| check | 48 | 1.6 | <0.01 |
| delete | 37 | 1.3 | <0.01 |
| show status | 34 | 1.2 | <0.01 |
| create table | 24 | 0.8 | <0.01 |
| truncate | 12 | 0.4 | <0.01 |
| delete multi | 8 | 0.3 | <0.01 |
| show processlist | 4 | 0.1 | <0.01 |
| show engine status | 3 | 0.1 | <0.01 |
| flush | 2 | 0.1 | <0.01 |
| create db | 1 | <0.1 | <0.01 |
| drop db | 1 | <0.1 | <0.01 |