| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 3,864 k | 314 k | 75.95 |
| show fields | 243 k | 19.8 k | 4.78 |
| show tables | 205 k | 16.7 k | 4.04 |
| show keys | 200 k | 16.3 k | 3.94 |
| change db | 164 k | 13.3 k | 3.22 |
| set option | 130 k | 10.6 k | 2.56 |
| show variables | 80,681 | 6,556.9 | 1.59 |
| show create table | 40,009 | 3,251.5 | 0.79 |
| show grants | 39,995 | 3,250.4 | 0.79 |
| show warnings | 39,990 | 3,250 | 0.79 |
| create table | 35,825 | 2,911.5 | 0.70 |
| stmt close | 12,024 | 977.2 | 0.24 |
| stmt execute | 12,024 | 977.2 | 0.24 |
| stmt prepare | 12,024 | 977.2 | 0.24 |
| insert | 5,018 | 407.8 | 0.10 |
| replace | 2,233 | 181.5 | 0.04 |
| show binlogs | 291 | 23.6 | 0.01 |
| show slave status | 33 | 2.7 | <0.01 |
| show master status | 30 | 2.4 | <0.01 |
| show table status | 14 | 1.1 | <0.01 |
| show storage engines | 9 | 0.7 | <0.01 |
| show status | 8 | 0.7 | <0.01 |
| show processlist | 1 | 0.1 | <0.01 |