| Statements | # | ø per hour | % |
|---|---|---|---|
| set option | 15,690 k | 55 k | 61.99 |
| select | 5,431 k | 19.1 k | 21.46 |
| commit | 3,892 k | 13.7 k | 15.38 |
| update | 207 k | 727.5 | 0.82 |
| show variables | 23,930 | 84 | 0.09 |
| show collations | 22,516 | 79 | 0.09 |
| change db | 12,643 | 44.4 | 0.05 |
| show tables | 8,920 | 31.3 | 0.04 |
| insert | 5,447 | 19.1 | 0.02 |
| show fields | 4,123 | 14.5 | 0.02 |
| show keys | 3,591 | 12.6 | 0.01 |
| delete | 2,628 | 9.2 | 0.01 |
| insert select | 2,622 | 9.2 | 0.01 |
| show create table | 962 | 3.4 | <0.01 |
| show storage engines | 255 | 0.9 | <0.01 |
| show table status | 203 | 0.7 | <0.01 |
| show grants | 186 | 0.7 | <0.01 |
| show warnings | 147 | 0.5 | <0.01 |
| show binlogs | 115 | 0.4 | <0.01 |
| stmt prepare | 58 | 0.2 | <0.01 |
| stmt close | 56 | 0.2 | <0.01 |
| stmt execute | 56 | 0.2 | <0.01 |
| show slave status | 47 | 0.2 | <0.01 |
| show master status | 44 | 0.2 | <0.01 |
| show status | 18 | 0.1 | <0.01 |
| show charsets | 3 | <0.1 | <0.01 |
| show function status | 3 | <0.1 | <0.01 |
| show procedure status | 3 | <0.1 | <0.01 |
| show processlist | 3 | <0.1 | <0.01 |
| flush | 1 | <0.1 | <0.01 |
| show databases | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |