Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 11,859 k | 14.1 k | 33.05 |
| stmt execute | 6,771 k | 8,046.1 | 18.87 |
| insert | 3,835 k | 4,558 | 10.69 |
| stmt prepare | 3,626 k | 4,309.2 | 10.11 |
| stmt close | 3,623 k | 4,305.3 | 10.10 |
| show fields | 2,195 k | 2,608.3 | 6.12 |
| update | 1,911 k | 2,271 | 5.33 |
| show tables | 680 k | 807.9 | 1.89 |
| change db | 460 k | 546.1 | 1.28 |
| set option | 353 k | 419.9 | 0.98 |
| show keys | 204 k | 242.5 | 0.57 |
| show grants | 93,405 | 111 | 0.26 |
| show variables | 80,042 | 95.1 | 0.22 |
| replace | 77,250 | 91.8 | 0.22 |
| show create table | 54,870 | 65.2 | 0.15 |
| show warnings | 25,668 | 30.5 | 0.07 |
| show storage engines | 14,031 | 16.7 | 0.04 |
| show binlogs | 8,029 | 9.5 | 0.02 |
| show table status | 4,433 | 5.3 | 0.01 |
| delete | 1,894 | 2.3 | 0.01 |
| show slave status | 1,683 | 2 | <0.01 |
| show master status | 1,657 | 2 | <0.01 |
| alter table | 179 | 0.2 | <0.01 |
| show status | 158 | 0.2 | <0.01 |
| truncate | 156 | 0.2 | <0.01 |
| create table | 87 | 0.1 | <0.01 |
| commit | 53 | 0.1 | <0.01 |
| begin | 52 | 0.1 | <0.01 |
| flush | 22 | <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 |