| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 600 k | 1,223.5 | 80.98 |
| show tables | 47,064 | 96 | 6.36 |
| show fields | 28,529 | 58.2 | 3.85 |
| change db | 26,286 | 53.6 | 3.55 |
| set option | 23,948 | 48.9 | 3.23 |
| show keys | 4,887 | 10 | 0.66 |
| update | 2,601 | 5.3 | 0.35 |
| replace | 1,476 | 3 | 0.20 |
| show variables | 1,325 | 2.7 | 0.18 |
| show create table | 1,072 | 2.2 | 0.14 |
| show grants | 706 | 1.4 | 0.10 |
| insert | 558 | 1.1 | 0.08 |
| stmt execute | 438 | 0.9 | 0.06 |
| show storage engines | 337 | 0.7 | 0.05 |
| create table | 328 | 0.7 | 0.04 |
| show warnings | 309 | 0.6 | 0.04 |
| stmt prepare | 254 | 0.5 | 0.03 |
| show binlogs | 133 | 0.3 | 0.02 |
| alter table | 123 | 0.3 | 0.02 |
| delete | 100 | 0.2 | 0.01 |
| stmt close | 72 | 0.1 | 0.01 |
| show table status | 60 | 0.1 | 0.01 |
| begin | 44 | 0.1 | 0.01 |
| commit | 44 | 0.1 | 0.01 |
| show slave status | 44 | 0.1 | 0.01 |
| show master status | 40 | 0.1 | 0.01 |
| show status | 18 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |
| show processlist | 2 | <0.1 | <0.01 |
| show engine status | 1 | <0.1 | <0.01 |