Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 12,995 k | 949.5 k | 95.37 |
| show tables | 136 k | 9,918.5 | 1.00 |
| show fields | 128 k | 9,383.4 | 0.94 |
| change db | 96,577 | 7,056.3 | 0.71 |
| set option | 76,652 | 5,600.5 | 0.56 |
| show keys | 34,275 | 2,504.3 | 0.25 |
| stmt execute | 27,224 | 1,989.1 | 0.20 |
| stmt prepare | 27,219 | 1,988.7 | 0.20 |
| stmt close | 27,214 | 1,988.4 | 0.20 |
| replace | 20,427 | 1,492.5 | 0.15 |
| show variables | 18,206 | 1,330.2 | 0.13 |
| show create table | 13,609 | 994.3 | 0.10 |
| create table | 8,404 | 614 | 0.06 |
| show warnings | 6,472 | 472.9 | 0.05 |
| show storage engines | 4,272 | 312.1 | 0.03 |
| show grants | 1,355 | 99 | 0.01 |
| delete | 716 | 52.3 | 0.01 |
| update | 698 | 51 | 0.01 |
| show table status | 697 | 50.9 | 0.01 |
| insert | 630 | 46 | <0.01 |
| show slave status | 404 | 29.5 | <0.01 |
| show master status | 397 | 29 | <0.01 |
| show binlogs | 225 | 16.4 | <0.01 |
| show status | 159 | 11.6 | <0.01 |
| begin | 124 | 9.1 | <0.01 |
| commit | 124 | 9.1 | <0.01 |
| show collations | 92 | 6.7 | <0.01 |
| lock tables | 19 | 1.4 | <0.01 |
| unlock tables | 19 | 1.4 | <0.01 |
| alter table | 18 | 1.3 | <0.01 |
| revoke | 10 | 0.7 | <0.01 |
| grant | 9 | 0.7 | <0.01 |
| show charsets | 8 | 0.6 | <0.01 |
| show function status | 8 | 0.6 | <0.01 |
| show procedure status | 8 | 0.6 | <0.01 |
| show create db | 7 | 0.5 | <0.01 |
| show engine status | 6 | 0.4 | <0.01 |
| show events | 6 | 0.4 | <0.01 |
| show package status | 6 | 0.4 | <0.01 |
| show package body status | 6 | 0.4 | <0.01 |
| show processlist | 6 | 0.4 | <0.01 |
| flush | 4 | 0.3 | <0.01 |
| show databases | 3 | 0.2 | <0.01 |
| create user | 2 | 0.1 | <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 |