| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 8,561 k | 619.4 k | 88.17 |
| show fields | 245 k | 17.7 k | 2.52 |
| show tables | 231 k | 16.7 k | 2.38 |
| change db | 173 k | 12.5 k | 1.79 |
| show keys | 168 k | 12.1 k | 1.73 |
| set option | 130 k | 9,411.2 | 1.34 |
| show variables | 64,423 | 4,660.6 | 0.66 |
| show create table | 34,421 | 2,490.2 | 0.35 |
| show grants | 34,068 | 2,464.6 | 0.35 |
| show warnings | 30,544 | 2,209.7 | 0.31 |
| replace | 20,714 | 1,498.5 | 0.21 |
| show create proc | 4,009 | 290 | 0.04 |
| show create func | 3,404 | 246.3 | 0.04 |
| update | 3,006 | 217.5 | 0.03 |
| show storage engines | 2,529 | 183 | 0.03 |
| show binlogs | 944 | 68.3 | 0.01 |
| insert | 929 | 67.2 | 0.01 |
| show table status | 387 | 28 | <0.01 |
| stmt close | 386 | 27.9 | <0.01 |
| stmt execute | 386 | 27.9 | <0.01 |
| stmt prepare | 386 | 27.9 | <0.01 |
| delete | 192 | 13.9 | <0.01 |
| show slave status | 119 | 8.6 | <0.01 |
| show binlog status | 111 | 8 | <0.01 |
| create table | 58 | 4.2 | <0.01 |
| show status | 37 | 2.7 | <0.01 |
| alter table | 17 | 1.2 | <0.01 |
| insert select | 8 | 0.6 | <0.01 |
| delete multi | 6 | 0.4 | <0.01 |
| show processlist | 5 | 0.4 | <0.01 |
| update multi | 3 | 0.2 | <0.01 |
| create db | 2 | 0.1 | <0.01 |
| flush | 2 | 0.1 | <0.01 |
| show engine status | 2 | 0.1 | <0.01 |