| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 480 k | 211.1 k | 76.49 |
| show tables | 32,729 | 14.4 k | 5.22 |
| show fields | 32,031 | 14.1 k | 5.11 |
| change db | 23,580 | 10.4 k | 3.76 |
| set option | 18,852 | 8,292.7 | 3.01 |
| show keys | 15,801 | 6,950.6 | 2.52 |
| show variables | 5,223 | 2,297.5 | 0.83 |
| alter table | 5,136 | 2,259.2 | 0.82 |
| replace | 4,511 | 1,984.3 | 0.72 |
| show create table | 3,429 | 1,508.4 | 0.55 |
| show warnings | 1,927 | 847.7 | 0.31 |
| update | 1,691 | 743.8 | 0.27 |
| show storage engines | 682 | 300 | 0.11 |
| show grants | 402 | 176.8 | 0.06 |
| insert | 281 | 123.6 | 0.04 |
| delete | 272 | 119.6 | 0.04 |
| show binlogs | 161 | 70.8 | 0.03 |
| stmt close | 122 | 53.7 | 0.02 |
| stmt execute | 122 | 53.7 | 0.02 |
| stmt prepare | 122 | 53.7 | 0.02 |
| show table status | 109 | 47.9 | 0.02 |
| update multi | 106 | 46.6 | 0.02 |
| show slave status | 70 | 30.8 | 0.01 |
| show master status | 66 | 29 | 0.01 |
| show status | 20 | 8.8 | <0.01 |
| show processlist | 4 | 1.8 | <0.01 |
| flush | 1 | 0.4 | <0.01 |
| insert select | 1 | 0.4 | <0.01 |
| show engine status | 1 | 0.4 | <0.01 |