| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 2,744 k | 22.1 k | 76.77 |
| show fields | 170 k | 1,371.3 | 4.76 |
| show tables | 156 k | 1,257.6 | 4.36 |
| show keys | 122 k | 987.2 | 3.43 |
| change db | 120 k | 965.1 | 3.35 |
| set option | 89,360 | 720.5 | 2.50 |
| show variables | 50,282 | 405.4 | 1.41 |
| show grants | 28,369 | 228.7 | 0.79 |
| show create table | 25,393 | 204.7 | 0.71 |
| show warnings | 23,825 | 192.1 | 0.67 |
| stmt execute | 12,072 | 97.3 | 0.34 |
| stmt prepare | 11,724 | 94.5 | 0.33 |
| stmt close | 11,714 | 94.4 | 0.33 |
| replace | 5,445 | 43.9 | 0.15 |
| show storage engines | 1,082 | 8.7 | 0.03 |
| insert | 784 | 6.3 | 0.02 |
| show table status | 375 | 3 | 0.01 |
| begin | 311 | 2.5 | 0.01 |
| commit | 304 | 2.5 | 0.01 |
| show binlogs | 254 | 2 | 0.01 |
| update | 252 | 2 | 0.01 |
| show slave status | 140 | 1.1 | <0.01 |
| alter table | 135 | 1.1 | <0.01 |
| show master status | 134 | 1.1 | <0.01 |
| create table | 58 | 0.5 | <0.01 |
| update multi | 43 | 0.3 | <0.01 |
| delete | 31 | 0.2 | <0.01 |
| show status | 24 | 0.2 | <0.01 |
| truncate | 19 | 0.2 | <0.01 |
| rollback | 7 | 0.1 | <0.01 |
| create db | 5 | <0.1 | <0.01 |
| drop db | 3 | <0.1 | <0.01 |
| show charsets | 2 | <0.1 | <0.01 |
| show function status | 2 | <0.1 | <0.01 |
| show procedure status | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| empty query | 1 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |