| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 540 M | 469 k | 65.80 |
| set option | 76,340 k | 66.4 k | 9.31 |
| show tables | 69,220 k | 60.2 k | 8.44 |
| show fields | 40,220 k | 35 k | 4.91 |
| change db | 30,256 k | 26.3 k | 3.69 |
| show variables | 18,606 k | 16.2 k | 2.27 |
| show keys | 9,315 k | 8,097.1 | 1.14 |
| show grants | 9,309 k | 8,091.2 | 1.14 |
| show create table | 9,306 k | 8,088.7 | 1.13 |
| show warnings | 9,301 k | 8,084.3 | 1.13 |
| update | 5,699 k | 4,954 | 0.70 |
| show binlogs | 2,306 k | 2,004.8 | 0.28 |
| insert | 515 k | 447.5 | 0.06 |
| delete | 32,952 | 28.6 | <0.01 |
| delete multi | 8,495 | 7.4 | <0.01 |
| insert select | 2,785 | 2.4 | <0.01 |
| show storage engines | 2,472 | 2.1 | <0.01 |
| show table status | 386 | 0.3 | <0.01 |
| show binlog status | 245 | 0.2 | <0.01 |
| show slave status | 245 | 0.2 | <0.01 |
| show status | 121 | 0.1 | <0.01 |
| replace | 31 | <0.1 | <0.01 |
| show processlist | 11 | <0.1 | <0.01 |
| show engine status | 10 | <0.1 | <0.01 |
| show create func | 8 | <0.1 | <0.01 |