| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 633 k | 142.8 k | 77.94 |
| show tables | 38,257 | 8,635.4 | 4.71 |
| show fields | 37,803 | 8,532.9 | 4.66 |
| change db | 28,136 | 6,350.8 | 3.47 |
| show keys | 24,506 | 5,531.5 | 3.02 |
| set option | 20,709 | 4,674.4 | 2.55 |
| show variables | 9,438 | 2,130.3 | 1.16 |
| show grants | 6,194 | 1,398.1 | 0.76 |
| show create table | 4,887 | 1,103.1 | 0.60 |
| show warnings | 4,150 | 936.7 | 0.51 |
| replace | 2,896 | 653.7 | 0.36 |
| show storage engines | 532 | 120.1 | 0.07 |
| stmt prepare | 339 | 76.5 | 0.04 |
| stmt close | 338 | 76.3 | 0.04 |
| stmt execute | 338 | 76.3 | 0.04 |
| show binlogs | 248 | 56 | 0.03 |
| show table status | 69 | 15.6 | 0.01 |
| show slave status | 60 | 13.5 | 0.01 |
| show master status | 54 | 12.2 | 0.01 |
| show status | 19 | 4.3 | <0.01 |
| insert | 13 | 2.9 | <0.01 |
| update | 11 | 2.5 | <0.01 |
| create table | 7 | 1.6 | <0.01 |
| delete | 7 | 1.6 | <0.01 |
| drop table | 7 | 1.6 | <0.01 |
| flush | 2 | 0.5 | <0.01 |
| create db | 1 | 0.2 | <0.01 |
| create user | 1 | 0.2 | <0.01 |
| empty query | 1 | 0.2 | <0.01 |
| grant | 1 | 0.2 | <0.01 |
| show engine status | 1 | 0.2 | <0.01 |
| show plugins | 1 | 0.2 | <0.01 |
| show processlist | 1 | 0.2 | <0.01 |