| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,492 k | 5,929.5 | 65.78 |
| stmt execute | 127 k | 504.4 | 5.60 |
| stmt prepare | 127 k | 504.4 | 5.60 |
| stmt close | 123 k | 487.4 | 5.41 |
| show fields | 89,853 | 357.1 | 3.96 |
| show tables | 89,143 | 354.3 | 3.93 |
| change db | 64,584 | 256.7 | 2.85 |
| set option | 49,779 | 197.8 | 2.19 |
| show keys | 49,181 | 195.5 | 2.17 |
| show variables | 19,218 | 76.4 | 0.85 |
| replace | 13,692 | 54.4 | 0.60 |
| show create table | 11,280 | 44.8 | 0.50 |
| show warnings | 8,514 | 33.8 | 0.38 |
| insert | 2,022 | 8 | 0.09 |
| show storage engines | 1,364 | 5.4 | 0.06 |
| show slave status | 197 | 0.8 | 0.01 |
| show master status | 191 | 0.8 | 0.01 |
| update | 174 | 0.7 | 0.01 |
| show table status | 138 | 0.5 | 0.01 |
| show grants | 137 | 0.5 | 0.01 |
| show binlogs | 94 | 0.4 | <0.01 |
| show status | 27 | 0.1 | <0.01 |
| delete | 22 | 0.1 | <0.01 |
| insert select | 10 | <0.1 | <0.01 |
| show processlist | 4 | <0.1 | <0.01 |
| load | 3 | <0.1 | <0.01 |
| show engine status | 2 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| truncate | 1 | <0.1 | <0.01 |