| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 848 k | 158.3 k | 77.77 |
| show fields | 51,243 | 9,563.7 | 4.70 |
| show tables | 50,931 | 9,505.5 | 4.67 |
| change db | 37,772 | 7,049.6 | 3.46 |
| show keys | 34,415 | 6,423 | 3.15 |
| set option | 27,888 | 5,204.9 | 2.56 |
| show variables | 13,485 | 2,516.8 | 1.24 |
| show grants | 8,059 | 1,504.1 | 0.74 |
| show create table | 6,819 | 1,272.7 | 0.63 |
| show warnings | 6,006 | 1,120.9 | 0.55 |
| replace | 3,563 | 665 | 0.33 |
| show storage engines | 566 | 105.6 | 0.05 |
| stmt prepare | 372 | 69.4 | 0.03 |
| stmt close | 371 | 69.2 | 0.03 |
| stmt execute | 371 | 69.2 | 0.03 |
| show binlogs | 323 | 60.3 | 0.03 |
| show table status | 80 | 14.9 | 0.01 |
| show slave status | 73 | 13.6 | 0.01 |
| show master status | 66 | 12.3 | 0.01 |
| show status | 29 | 5.4 | <0.01 |
| insert | 13 | 2.4 | <0.01 |
| update | 11 | 2.1 | <0.01 |
| create table | 7 | 1.3 | <0.01 |
| delete | 7 | 1.3 | <0.01 |
| drop table | 7 | 1.3 | <0.01 |
| flush | 2 | 0.4 | <0.01 |
| show processlist | 2 | 0.4 | <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 |