Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 11,760 k | 14 k | 32.89 |
| stmt execute | 6,770 k | 8,082.1 | 18.94 |
| insert | 3,835 k | 4,578.5 | 10.73 |
| stmt prepare | 3,626 k | 4,328.3 | 10.14 |
| stmt close | 3,623 k | 4,324.4 | 10.13 |
| show fields | 2,189 k | 2,613 | 6.12 |
| update | 1,911 k | 2,281.2 | 5.34 |
| show tables | 673 k | 803.5 | 1.88 |
| change db | 455 k | 543.3 | 1.27 |
| set option | 350 k | 417.7 | 0.98 |
| show keys | 202 k | 240.9 | 0.56 |
| show grants | 92,362 | 110.3 | 0.26 |
| show variables | 79,437 | 94.8 | 0.22 |
| replace | 76,287 | 91.1 | 0.21 |
| show create table | 54,227 | 64.7 | 0.15 |
| show warnings | 25,470 | 30.4 | 0.07 |
| show storage engines | 13,802 | 16.5 | 0.04 |
| show binlogs | 7,997 | 9.5 | 0.02 |
| show table status | 4,377 | 5.2 | 0.01 |
| delete | 1,894 | 2.3 | 0.01 |
| show slave status | 1,672 | 2 | <0.01 |
| show master status | 1,646 | 2 | <0.01 |
| alter table | 179 | 0.2 | <0.01 |
| truncate | 156 | 0.2 | <0.01 |
| show status | 154 | 0.2 | <0.01 |
| create table | 87 | 0.1 | <0.01 |
| commit | 53 | 0.1 | <0.01 |
| begin | 52 | 0.1 | <0.01 |
| flush | 21 | <0.1 | <0.01 |
| insert select | 20 | <0.1 | <0.01 |
| show processlist | 19 | <0.1 | <0.01 |
| show engine status | 16 | <0.1 | <0.01 |
| show function status | 13 | <0.1 | <0.01 |
| show procedure status | 13 | <0.1 | <0.01 |
| drop table | 12 | <0.1 | <0.01 |
| grant | 9 | <0.1 | <0.01 |
| create db | 7 | <0.1 | <0.01 |
| alter user | 5 | <0.1 | <0.01 |
| create user | 4 | <0.1 | <0.01 |
| show databases | 3 | <0.1 | <0.01 |
| drop db | 3 | <0.1 | <0.01 |
| rollback | 2 | <0.1 | <0.01 |
| load | 2 | <0.1 | <0.01 |
| drop procedure | 2 | <0.1 | <0.01 |
| delete multi | 2 | <0.1 | <0.01 |
| create procedure | 1 | <0.1 | <0.01 |
| empty query | 1 | <0.1 | <0.01 |
| call procedure | 1 | <0.1 | <0.01 |
| alter db | 1 | <0.1 | <0.01 |