| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 44,185 | 483.1 | 48.30 |
| set option | 9,922 | 108.5 | 10.85 |
| show tables | 8,601 | 94 | 9.40 |
| show keys | 5,265 | 57.6 | 5.76 |
| show fields | 4,991 | 54.6 | 5.46 |
| change db | 4,108 | 44.9 | 4.49 |
| stmt execute | 2,900 | 31.7 | 3.17 |
| stmt prepare | 2,900 | 31.7 | 3.17 |
| stmt close | 2,601 | 28.4 | 2.84 |
| show variables | 2,488 | 27.2 | 2.72 |
| show create table | 1,117 | 12.2 | 1.22 |
| show grants | 779 | 8.5 | 0.85 |
| show warnings | 407 | 4.5 | 0.44 |
| show binlogs | 350 | 3.8 | 0.38 |
| show storage engines | 329 | 3.6 | 0.36 |
| insert | 166 | 1.8 | 0.18 |
| show table status | 130 | 1.4 | 0.14 |
| show slave status | 90 | 1 | 0.10 |
| show master status | 84 | 0.9 | 0.09 |
| show status | 38 | 0.4 | 0.04 |
| show create proc | 12 | 0.1 | 0.01 |
| show create func | 6 | 0.1 | 0.01 |
| show processlist | 5 | 0.1 | 0.01 |
| show engine status | 4 | <0.1 | <0.01 |
| flush | 2 | <0.1 | <0.01 |