| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 433 M | 4,299.4 k | 86.77 |
| stmt execute | 11,233 k | 111.5 k | 2.25 |
| stmt prepare | 11,204 k | 111.2 k | 2.24 |
| stmt close | 11,203 k | 111.2 k | 2.24 |
| set option | 7,983 k | 79.3 k | 1.60 |
| insert | 7,946 k | 78.9 k | 1.59 |
| update | 4,918 k | 48.8 k | 0.99 |
| change db | 2,416 k | 24 k | 0.48 |
| show fields | 2,124 k | 21.1 k | 0.43 |
| show tables | 1,505 k | 14.9 k | 0.30 |
| show keys | 1,201 k | 11.9 k | 0.24 |
| delete | 928 k | 9,211.7 | 0.19 |
| show variables | 864 k | 8,577.2 | 0.17 |
| show status | 369 k | 3,666.4 | 0.07 |
| show engine status | 363 k | 3,599.5 | 0.07 |
| show generic | 363 k | 3,599.5 | 0.07 |
| show create table | 329 k | 3,263.3 | 0.07 |
| show grants | 245 k | 2,429.8 | 0.05 |
| show warnings | 238 k | 2,365.5 | 0.05 |
| update multi | 108 k | 1,074.9 | 0.02 |
| show processlist | 97,944 | 972.4 | 0.02 |
| insert select | 82,753 | 821.6 | 0.02 |
| rollback to savepoint | 61,710 | 612.6 | 0.01 |
| alter table | 51,080 | 507.1 | 0.01 |
| repair | 44,802 | 444.8 | 0.01 |
| replace | 19,897 | 197.5 | <0.01 |
| begin | 19,109 | 189.7 | <0.01 |
| commit | 17,387 | 172.6 | <0.01 |
| show databases | 17,056 | 169.3 | <0.01 |
| create table | 13,995 | 138.9 | <0.01 |
| delete multi | 12,488 | 124 | <0.01 |
| empty query | 7,636 | 75.8 | <0.01 |
| enable governor lve | 6,036 | 59.9 | <0.01 |
| alter user | 5,746 | 57 | <0.01 |
| show table status | 4,045 | 40.2 | <0.01 |
| unlock tables | 3,386 | 33.6 | <0.01 |
| grant | 2,317 | 23 | <0.01 |
| stmt send long data | 1,983 | 19.7 | <0.01 |
| lock tables | 1,702 | 16.9 | <0.01 |
| savepoint | 1,654 | 16.4 | <0.01 |
| release savepoint | 1,636 | 16.2 | <0.01 |
| drop table | 1,041 | 10.3 | <0.01 |
| check | 894 | 8.9 | <0.01 |
| show function status | 866 | 8.6 | <0.01 |
| show procedure status | 866 | 8.6 | <0.01 |
| show events | 840 | 8.3 | <0.01 |
| show package status | 822 | 8.2 | <0.01 |
| show package body status | 822 | 8.2 | <0.01 |
| show create db | 818 | 8.1 | <0.01 |
| do | 691 | 6.9 | <0.01 |
| truncate | 367 | 3.6 | <0.01 |
| flush | 344 | 3.4 | <0.01 |
| show create trigger | 288 | 2.9 | <0.01 |
| show binlogs | 184 | 1.8 | <0.01 |
| show slave status | 148 | 1.5 | <0.01 |
| show binlog status | 144 | 1.4 | <0.01 |
| rollback | 125 | 1.2 | <0.01 |
| show storage engines | 119 | 1.2 | <0.01 |
| create view | 98 | 1 | <0.01 |
| create user | 64 | 0.6 | <0.01 |
| drop user | 48 | 0.5 | <0.01 |
| show create proc | 48 | 0.5 | <0.01 |
| drop view | 38 | 0.4 | <0.01 |
| show triggers | 37 | 0.4 | <0.01 |
| drop db | 35 | 0.3 | <0.01 |
| show create func | 35 | 0.3 | <0.01 |
| show charsets | 31 | 0.3 | <0.01 |
| create db | 25 | 0.2 | <0.01 |
| create function | 20 | 0.2 | <0.01 |
| enable governor reconn lve | 18 | 0.2 | <0.01 |
| show collations | 18 | 0.2 | <0.01 |
| drop function | 10 | 0.1 | <0.01 |
| optimize | 9 | 0.1 | <0.01 |
| create temporary table | 6 | 0.1 | <0.01 |
| create trigger | 5 | <0.1 | <0.01 |
| alter db | 3 | <0.1 | <0.01 |
| create index | 3 | <0.1 | <0.01 |
| revoke | 2 | <0.1 | <0.01 |
| kill | 1 | <0.1 | <0.01 |
| rename table | 1 | <0.1 | <0.01 |