| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 44,056 | 93.1 | 82.44 |
| show tables | 2,800 | 5.9 | 5.24 |
| change db | 2,211 | 4.7 | 4.14 |
| set option | 1,663 | 3.5 | 3.11 |
| show fields | 1,661 | 3.5 | 3.11 |
| show variables | 529 | 1.1 | 0.99 |
| insert | 125 | 0.3 | 0.23 |
| show grants | 84 | 0.2 | 0.16 |
| show binlogs | 77 | 0.2 | 0.14 |
| update | 57 | 0.1 | 0.11 |
| show create table | 53 | 0.1 | 0.10 |
| begin | 24 | 0.1 | 0.04 |
| commit | 24 | 0.1 | 0.04 |
| show slave status | 12 | <0.1 | 0.02 |
| show master status | 11 | <0.1 | 0.02 |
| stmt close | 9 | <0.1 | 0.02 |
| stmt execute | 9 | <0.1 | 0.02 |
| stmt prepare | 9 | <0.1 | 0.02 |
| show keys | 8 | <0.1 | 0.01 |
| delete | 3 | <0.1 | 0.01 |
| show status | 3 | <0.1 | 0.01 |
| show table status | 3 | <0.1 | 0.01 |
| show storage engines | 2 | <0.1 | <0.01 |
| show collations | 1 | <0.1 | <0.01 |
| show databases | 1 | <0.1 | <0.01 |
| show function status | 1 | <0.1 | <0.01 |
| show open tables | 1 | <0.1 | <0.01 |
| show procedure status | 1 | <0.1 | <0.01 |
| show triggers | 1 | <0.1 | <0.01 |