Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 24,581 | 7,992.4 | 44.51 |
| set option | 6,089 | 1,979.8 | 11.03 |
| show tables | 5,065 | 1,646.9 | 9.17 |
| show fields | 3,631 | 1,180.6 | 6.58 |
| show keys | 3,100 | 1,007.9 | 5.61 |
| change db | 2,483 | 807.3 | 4.50 |
| stmt execute | 1,999 | 650 | 3.62 |
| stmt close | 1,806 | 587.2 | 3.27 |
| stmt prepare | 1,806 | 587.2 | 3.27 |
| show variables | 1,352 | 439.6 | 2.45 |
| create table | 902 | 293.3 | 1.63 |
| show create table | 802 | 260.8 | 1.45 |
| show grants | 301 | 97.9 | 0.55 |
| show storage engines | 269 | 87.5 | 0.49 |
| alter table | 244 | 79.3 | 0.44 |
| show warnings | 158 | 51.4 | 0.29 |
| show binlogs | 109 | 35.4 | 0.20 |
| insert | 90 | 29.3 | 0.16 |
| lock tables | 82 | 26.7 | 0.15 |
| unlock tables | 82 | 26.7 | 0.15 |
| drop table | 79 | 25.7 | 0.14 |
| update | 53 | 17.2 | 0.10 |
| show slave status | 44 | 14.3 | 0.08 |
| show master status | 41 | 13.3 | 0.07 |
| show table status | 26 | 8.5 | 0.05 |
| show status | 13 | 4.2 | 0.02 |
| create db | 3 | 1 | 0.01 |
| show databases | 3 | 1 | 0.01 |
| show processlist | 2 | 0.7 | <0.01 |
| delete | 1 | 0.3 | <0.01 |
| show engine status | 1 | 0.3 | <0.01 |
| show events | 1 | 0.3 | <0.01 |
| show function status | 1 | 0.3 | <0.01 |
| show package status | 1 | 0.3 | <0.01 |
| show package body status | 1 | 0.3 | <0.01 |
| show procedure status | 1 | 0.3 | <0.01 |