Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 5,546 k | 1,463.5 | 79.00 |
| show tables | 314 k | 82.8 | 4.47 |
| show fields | 300 k | 79.1 | 4.27 |
| set option | 231 k | 60.9 | 3.29 |
| change db | 222 k | 58.7 | 3.17 |
| show keys | 127 k | 33.4 | 1.80 |
| replace | 52,080 | 13.7 | 0.74 |
| show variables | 50,531 | 13.3 | 0.72 |
| show create table | 35,910 | 9.5 | 0.51 |
| stmt execute | 31,337 | 8.3 | 0.45 |
| show warnings | 19,888 | 5.2 | 0.28 |
| stmt prepare | 19,808 | 5.2 | 0.28 |
| stmt close | 19,461 | 5.1 | 0.28 |
| insert | 19,178 | 5.1 | 0.27 |
| update | 9,935 | 2.6 | 0.14 |
| show storage engines | 8,054 | 2.1 | 0.11 |
| show status | 5,642 | 1.5 | 0.08 |
| delete | 3,137 | 0.8 | 0.04 |
| show grants | 1,770 | 0.5 | 0.03 |
| show table status | 844 | 0.2 | 0.01 |
| show binlogs | 661 | 0.2 | 0.01 |
| show slave status | 557 | 0.1 | 0.01 |
| show master status | 539 | 0.1 | 0.01 |
| empty query | 534 | 0.1 | 0.01 |
| create table | 312 | 0.1 | <0.01 |
| commit | 227 | 0.1 | <0.01 |
| begin | 225 | 0.1 | <0.01 |
| show charsets | 130 | <0.1 | <0.01 |
| lock tables | 94 | <0.1 | <0.01 |
| unlock tables | 94 | <0.1 | <0.01 |
| alter table | 80 | <0.1 | <0.01 |
| show databases | 49 | <0.1 | <0.01 |
| drop table | 40 | <0.1 | <0.01 |
| show procedure status | 38 | <0.1 | <0.01 |
| show collations | 36 | <0.1 | <0.01 |
| drop db | 15 | <0.1 | <0.01 |
| show processlist | 15 | <0.1 | <0.01 |
| create db | 13 | <0.1 | <0.01 |
| show engine status | 12 | <0.1 | <0.01 |
| show create db | 10 | <0.1 | <0.01 |
| flush | 7 | <0.1 | <0.01 |
| show plugins | 6 | <0.1 | <0.01 |