| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 718 M | 11.2 M | 91.71 |
| set option | 9,720 k | 151.3 k | 1.24 |
| replace | 9,065 k | 141.1 k | 1.16 |
| stmt execute | 8,798 k | 137 k | 1.12 |
| stmt prepare | 8,757 k | 136.3 k | 1.12 |
| stmt close | 8,757 k | 136.3 k | 1.12 |
| update | 7,389 k | 115 k | 0.94 |
| show fields | 2,770 k | 43.1 k | 0.35 |
| change db | 2,731 k | 42.5 k | 0.35 |
| insert | 2,381 k | 37.1 k | 0.30 |
| show tables | 1,021 k | 15.9 k | 0.13 |
| delete | 857 k | 13.3 k | 0.11 |
| show status | 404 k | 6,281.9 | 0.05 |
| show keys | 401 k | 6,234.9 | 0.05 |
| show variables | 393 k | 6,121 | 0.05 |
| insert select | 241 k | 3,752.4 | 0.03 |
| show engine status | 231 k | 3,600 | 0.03 |
| show generic | 231 k | 3,599.9 | 0.03 |
| show databases | 124 k | 1,934.4 | 0.02 |
| show create table | 89,650 | 1,395.6 | 0.01 |
| show warnings | 77,017 | 1,199 | 0.01 |
| show processlist | 62,444 | 972.1 | 0.01 |
| call procedure | 55,012 | 856.4 | 0.01 |
| update multi | 53,640 | 835 | 0.01 |
| drop table | 44,954 | 699.8 | 0.01 |
| create temporary table | 44,335 | 690.2 | 0.01 |
| delete multi | 32,859 | 511.5 | <0.01 |
| alter table | 23,314 | 362.9 | <0.01 |
| create table | 21,791 | 339.2 | <0.01 |
| begin | 15,155 | 235.9 | <0.01 |
| rollback to savepoint | 14,574 | 226.9 | <0.01 |
| show profile | 10,325 | 160.7 | <0.01 |
| commit | 7,995 | 124.5 | <0.01 |
| rollback | 6,833 | 106.4 | <0.01 |
| show grants | 4,360 | 67.9 | <0.01 |
| enable governor lve | 3,853 | 60 | <0.01 |
| show table status | 1,218 | 19 | <0.01 |
| stmt send long data | 1,144 | 17.8 | <0.01 |
| show storage engines | 927 | 14.4 | <0.01 |
| unlock tables | 842 | 13.1 | <0.01 |
| show profiles | 697 | 10.9 | <0.01 |
| grant | 560 | 8.7 | <0.01 |
| check | 520 | 8.1 | <0.01 |
| lock tables | 512 | 8 | <0.01 |
| release savepoint | 330 | 5.1 | <0.01 |
| savepoint | 330 | 5.1 | <0.01 |
| show binlogs | 258 | 4 | <0.01 |
| truncate | 234 | 3.6 | <0.01 |
| show function status | 195 | 3 | <0.01 |
| show procedure status | 195 | 3 | <0.01 |
| show events | 179 | 2.8 | <0.01 |
| show create db | 165 | 2.6 | <0.01 |
| show package status | 165 | 2.6 | <0.01 |
| show package body status | 165 | 2.6 | <0.01 |
| show slave status | 130 | 2 | <0.01 |
| show binlog status | 129 | 2 | <0.01 |
| empty query | 75 | 1.2 | <0.01 |
| alter user | 68 | 1.1 | <0.01 |
| create user | 48 | 0.7 | <0.01 |
| show create trigger | 39 | 0.6 | <0.01 |
| create view | 35 | 0.5 | <0.01 |
| drop user | 30 | 0.5 | <0.01 |
| show triggers | 25 | 0.4 | <0.01 |
| do | 21 | 0.3 | <0.01 |
| revoke | 18 | 0.3 | <0.01 |
| flush | 15 | 0.2 | <0.01 |
| drop db | 14 | 0.2 | <0.01 |
| create db | 12 | 0.2 | <0.01 |
| show charsets | 10 | 0.2 | <0.01 |
| rename table | 8 | 0.1 | <0.01 |
| show create proc | 5 | 0.1 | <0.01 |
| create index | 3 | <0.1 | <0.01 |
| enable governor reconn lve | 3 | <0.1 | <0.01 |
| rename user | 3 | <0.1 | <0.01 |
| create procedure | 2 | <0.1 | <0.01 |
| create trigger | 2 | <0.1 | <0.01 |
| drop procedure | 2 | <0.1 | <0.01 |
| drop trigger | 2 | <0.1 | <0.01 |
| drop temporary table | 1 | <0.1 | <0.01 |