| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 374 k | 115.8 k | 78.54 |
| show tables | 23,823 | 7,366 | 5.00 |
| show fields | 21,456 | 6,634.2 | 4.50 |
| change db | 16,607 | 5,134.9 | 3.48 |
| set option | 12,237 | 3,783.7 | 2.57 |
| show keys | 11,622 | 3,593.5 | 2.44 |
| show variables | 4,464 | 1,380.3 | 0.94 |
| show grants | 3,839 | 1,187 | 0.81 |
| show create table | 2,371 | 733.1 | 0.50 |
| replace | 2,282 | 705.6 | 0.48 |
| show warnings | 1,805 | 558.1 | 0.38 |
| show storage engines | 443 | 137 | 0.09 |
| stmt prepare | 306 | 94.6 | 0.06 |
| stmt close | 305 | 94.3 | 0.06 |
| stmt execute | 305 | 94.3 | 0.06 |
| show binlogs | 190 | 58.7 | 0.04 |
| show table status | 58 | 17.9 | 0.01 |
| show slave status | 51 | 15.8 | 0.01 |
| show master status | 46 | 14.2 | 0.01 |
| show status | 17 | 5.3 | <0.01 |
| insert | 13 | 4 | <0.01 |
| update | 11 | 3.4 | <0.01 |
| create table | 7 | 2.2 | <0.01 |
| delete | 7 | 2.2 | <0.01 |
| drop table | 7 | 2.2 | <0.01 |
| create db | 1 | 0.3 | <0.01 |
| create user | 1 | 0.3 | <0.01 |
| empty query | 1 | 0.3 | <0.01 |
| flush | 1 | 0.3 | <0.01 |
| grant | 1 | 0.3 | <0.01 |
| show engine status | 1 | 0.3 | <0.01 |
| show plugins | 1 | 0.3 | <0.01 |
| show processlist | 1 | 0.3 | <0.01 |