| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 364 M | 4,810.6 k | 87.16 |
| stmt execute | 9,022 k | 119.3 k | 2.16 |
| stmt prepare | 9,007 k | 119.1 k | 2.16 |
| stmt close | 9,006 k | 119.1 k | 2.16 |
| set option | 7,271 k | 96.1 k | 1.74 |
| insert | 4,034 k | 53.3 k | 0.97 |
| update | 3,925 k | 51.9 k | 0.94 |
| change db | 2,142 k | 28.3 k | 0.51 |
| delete | 2,103 k | 27.8 k | 0.50 |
| show fields | 1,811 k | 23.9 k | 0.43 |
| show tables | 1,354 k | 17.9 k | 0.32 |
| show keys | 1,025 k | 13.6 k | 0.25 |
| show variables | 688 k | 9,094.8 | 0.16 |
| show create table | 289 k | 3,821 | 0.07 |
| show status | 278 k | 3,673.5 | 0.07 |
| show engine status | 272 k | 3,599.5 | 0.07 |
| show generic | 272 k | 3,599.5 | 0.07 |
| show grants | 210 k | 2,780.3 | 0.05 |
| show warnings | 203 k | 2,677.4 | 0.05 |
| replace | 116 k | 1,531.7 | 0.03 |
| insert select | 97,820 | 1,293.1 | 0.02 |
| update multi | 87,406 | 1,155.5 | 0.02 |
| alter table | 78,402 | 1,036.4 | 0.02 |
| show processlist | 73,540 | 972.2 | 0.02 |
| rollback to savepoint | 60,800 | 803.7 | 0.01 |
| repair | 45,221 | 597.8 | 0.01 |
| create table | 29,310 | 387.5 | 0.01 |
| begin | 14,226 | 188.1 | <0.01 |
| commit | 12,572 | 166.2 | <0.01 |
| show databases | 12,016 | 158.8 | <0.01 |
| delete multi | 8,321 | 110 | <0.01 |
| empty query | 5,237 | 69.2 | <0.01 |
| enable governor lve | 4,534 | 59.9 | <0.01 |
| alter user | 4,009 | 53 | <0.01 |
| show table status | 3,276 | 43.3 | <0.01 |
| unlock tables | 3,067 | 40.5 | <0.01 |
| grant | 2,543 | 33.6 | <0.01 |
| savepoint | 1,631 | 21.6 | <0.01 |
| release savepoint | 1,610 | 21.3 | <0.01 |
| lock tables | 1,407 | 18.6 | <0.01 |
| check | 1,168 | 15.4 | <0.01 |
| show function status | 842 | 11.1 | <0.01 |
| show procedure status | 842 | 11.1 | <0.01 |
| stmt send long data | 841 | 11.1 | <0.01 |
| show events | 823 | 10.9 | <0.01 |
| show create db | 805 | 10.6 | <0.01 |
| show package status | 805 | 10.6 | <0.01 |
| show package body status | 805 | 10.6 | <0.01 |
| drop table | 429 | 5.7 | <0.01 |
| truncate | 422 | 5.6 | <0.01 |
| flush | 334 | 4.4 | <0.01 |
| show create trigger | 292 | 3.9 | <0.01 |
| show slave status | 193 | 2.6 | <0.01 |
| show binlog status | 190 | 2.5 | <0.01 |
| show binlogs | 188 | 2.5 | <0.01 |
| create user | 118 | 1.6 | <0.01 |
| do | 115 | 1.5 | <0.01 |
| drop user | 96 | 1.3 | <0.01 |
| show storage engines | 64 | 0.8 | <0.01 |
| rollback | 53 | 0.7 | <0.01 |
| show create proc | 48 | 0.6 | <0.01 |
| create view | 46 | 0.6 | <0.01 |
| create db | 43 | 0.6 | <0.01 |
| drop db | 39 | 0.5 | <0.01 |
| show triggers | 38 | 0.5 | <0.01 |
| show create func | 35 | 0.5 | <0.01 |
| create sequence | 20 | 0.3 | <0.01 |
| enable governor reconn lve | 17 | 0.2 | <0.01 |
| show collations | 16 | 0.2 | <0.01 |
| kill | 12 | 0.2 | <0.01 |
| show charsets | 9 | 0.1 | <0.01 |
| alter db | 8 | 0.1 | <0.01 |
| create index | 6 | 0.1 | <0.01 |
| optimize | 6 | 0.1 | <0.01 |
| revoke | 6 | 0.1 | <0.01 |
| create temporary table | 5 | 0.1 | <0.01 |
| drop temporary table | 3 | <0.1 | <0.01 |
| create trigger | 2 | <0.1 | <0.01 |
| signal | 1 | <0.1 | <0.01 |