Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 11,955 k | 996.9 k | 97.23 |
| show tables | 62,007 | 5,170.7 | 0.50 |
| show fields | 61,812 | 5,154.5 | 0.50 |
| change db | 44,939 | 3,747.4 | 0.37 |
| set option | 39,128 | 3,262.9 | 0.32 |
| stmt execute | 26,910 | 2,244 | 0.22 |
| stmt prepare | 26,905 | 2,243.6 | 0.22 |
| stmt close | 26,900 | 2,243.2 | 0.22 |
| show keys | 14,642 | 1,221 | 0.12 |
| create table | 8,295 | 691.7 | 0.07 |
| replace | 7,956 | 663.4 | 0.06 |
| show variables | 6,632 | 553 | 0.05 |
| show create table | 6,012 | 501.3 | 0.05 |
| show storage engines | 2,716 | 226.5 | 0.02 |
| show warnings | 2,004 | 167.1 | 0.02 |
| update | 698 | 58.2 | 0.01 |
| insert | 630 | 52.5 | 0.01 |
| delete | 491 | 40.9 | <0.01 |
| show table status | 330 | 27.5 | <0.01 |
| show slave status | 242 | 20.2 | <0.01 |
| show master status | 236 | 19.7 | <0.01 |
| show grants | 161 | 13.4 | <0.01 |
| show status | 137 | 11.4 | <0.01 |
| begin | 124 | 10.3 | <0.01 |
| commit | 124 | 10.3 | <0.01 |
| show collations | 92 | 7.7 | <0.01 |
| show binlogs | 79 | 6.6 | <0.01 |
| lock tables | 19 | 1.6 | <0.01 |
| unlock tables | 19 | 1.6 | <0.01 |
| alter table | 18 | 1.5 | <0.01 |
| revoke | 10 | 0.8 | <0.01 |
| grant | 9 | 0.8 | <0.01 |
| show charsets | 8 | 0.7 | <0.01 |
| show function status | 8 | 0.7 | <0.01 |
| show procedure status | 8 | 0.7 | <0.01 |
| show create db | 7 | 0.6 | <0.01 |
| show events | 6 | 0.5 | <0.01 |
| show package status | 6 | 0.5 | <0.01 |
| show package body status | 6 | 0.5 | <0.01 |
| show databases | 3 | 0.3 | <0.01 |
| show processlist | 3 | 0.3 | <0.01 |
| create user | 2 | 0.2 | <0.01 |
| flush | 2 | 0.2 | <0.01 |
| show engine status | 2 | 0.2 | <0.01 |
| alter user | 1 | 0.1 | <0.01 |
| delete multi | 1 | 0.1 | <0.01 |
| drop user | 1 | 0.1 | <0.01 |
| empty query | 1 | 0.1 | <0.01 |
| show plugins | 1 | 0.1 | <0.01 |