| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 540 M | 469 k | 65.80 |
| set option | 76,423 k | 66.4 k | 9.31 |
| show tables | 69,301 k | 60.2 k | 8.44 |
| show fields | 40,295 k | 35 k | 4.91 |
| change db | 30,286 k | 26.3 k | 3.69 |
| show variables | 18,624 k | 16.2 k | 2.27 |
| show keys | 9,326 k | 8,097.8 | 1.14 |
| show grants | 9,317 k | 8,089.6 | 1.13 |
| show create table | 9,315 k | 8,088.3 | 1.13 |
| show warnings | 9,309 k | 8,082.9 | 1.13 |
| update | 5,710 k | 4,958.1 | 0.70 |
| show binlogs | 2,309 k | 2,004.7 | 0.28 |
| insert | 517 k | 449 | 0.06 |
| delete | 32,963 | 28.6 | <0.01 |
| delete multi | 8,506 | 7.4 | <0.01 |
| insert select | 2,787 | 2.4 | <0.01 |
| show storage engines | 2,763 | 2.4 | <0.01 |
| show table status | 549 | 0.5 | <0.01 |
| show binlog status | 252 | 0.2 | <0.01 |
| show slave status | 252 | 0.2 | <0.01 |
| show status | 128 | 0.1 | <0.01 |
| replace | 31 | <0.1 | <0.01 |
| show processlist | 12 | <0.1 | <0.01 |
| show engine status | 10 | <0.1 | <0.01 |
| show create func | 10 | <0.1 | <0.01 |