| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 450 M | 375.5 k | 66.69 |
| show tables | 45,368 k | 37.9 k | 6.73 |
| show fields | 39,916 k | 33.3 k | 5.92 |
| set option | 38,610 k | 32.2 k | 5.72 |
| change db | 32,672 k | 27.3 k | 4.84 |
| show variables | 20,773 k | 17.3 k | 3.08 |
| show keys | 10,415 k | 8,693.9 | 1.54 |
| show create table | 10,390 k | 8,672.7 | 1.54 |
| show warnings | 10,382 k | 8,666.6 | 1.54 |
| show grants | 9,911 k | 8,273.1 | 1.47 |
| update | 5,843 k | 4,877.8 | 0.87 |
| insert | 349 k | 291.6 | 0.05 |
| delete | 31,066 | 25.9 | <0.01 |
| delete multi | 9,434 | 7.9 | <0.01 |
| show binlogs | 7,198 | 6 | <0.01 |
| show storage engines | 4,350 | 3.6 | <0.01 |
| show binlog status | 3,636 | 3 | <0.01 |
| show slave status | 3,636 | 3 | <0.01 |
| insert select | 2,695 | 2.2 | <0.01 |
| show table status | 666 | 0.6 | <0.01 |
| show status | 215 | 0.2 | <0.01 |
| show processlist | 29 | <0.1 | <0.01 |
| show engine status | 23 | <0.1 | <0.01 |
| show create func | 17 | <0.1 | <0.01 |
| replace | 17 | <0.1 | <0.01 |