| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 828 M | 14.8 M | 92.74 |
| set option | 14,236 k | 253.9 k | 1.60 |
| stmt prepare | 9,331 k | 166.4 k | 1.05 |
| stmt execute | 9,328 k | 166.4 k | 1.05 |
| stmt close | 9,323 k | 166.3 k | 1.04 |
| update | 7,747 k | 138.2 k | 0.87 |
| change db | 4,436 k | 79.1 k | 0.50 |
| show fields | 3,203 k | 57.1 k | 0.36 |
| insert | 2,924 k | 52.2 k | 0.33 |
| show tables | 1,013 k | 18.1 k | 0.11 |
| delete | 930 k | 16.6 k | 0.10 |
| show status | 441 k | 7,867.1 | 0.05 |
| replace | 424 k | 7,564.3 | 0.05 |
| show variables | 212 k | 3,787.9 | 0.02 |
| show engine status | 202 k | 3,599.3 | 0.02 |
| show generic | 202 k | 3,598.9 | 0.02 |
| insert select | 193 k | 3,445.7 | 0.02 |
| show create table | 125 k | 2,237.9 | 0.01 |
| rollback to savepoint | 79,368 | 1,415.5 | 0.01 |
| update multi | 71,972 | 1,283.6 | 0.01 |
| show databases | 71,650 | 1,277.9 | 0.01 |
| repair | 70,281 | 1,253.4 | 0.01 |
| show processlist | 54,523 | 972.4 | 0.01 |
| alter table | 28,927 | 515.9 | <0.01 |
| show keys | 26,057 | 464.7 | <0.01 |
| create table | 20,736 | 369.8 | <0.01 |
| begin | 12,602 | 224.8 | <0.01 |
| show grants | 11,375 | 202.9 | <0.01 |
| show profile | 11,232 | 200.3 | <0.01 |
| delete multi | 10,739 | 191.5 | <0.01 |
| commit | 10,190 | 181.7 | <0.01 |
| savepoint | 8,083 | 144.2 | <0.01 |
| unlock tables | 6,472 | 115.4 | <0.01 |
| lock tables | 4,020 | 71.7 | <0.01 |
| truncate | 3,642 | 65 | <0.01 |
| enable governor lve | 3,356 | 59.9 | <0.01 |
| show table status | 3,202 | 57.1 | <0.01 |
| drop table | 2,718 | 48.5 | <0.01 |
| release savepoint | 2,400 | 42.8 | <0.01 |
| empty query | 2,177 | 38.8 | <0.01 |
| grant | 1,397 | 24.9 | <0.01 |
| alter user | 1,354 | 24.1 | <0.01 |
| show function status | 1,252 | 22.3 | <0.01 |
| show procedure status | 1,252 | 22.3 | <0.01 |
| show events | 1,225 | 21.8 | <0.01 |
| show package status | 1,203 | 21.5 | <0.01 |
| show package body status | 1,203 | 21.5 | <0.01 |
| show create db | 1,197 | 21.3 | <0.01 |
| show binlogs | 968 | 17.3 | <0.01 |
| show storage engines | 931 | 16.6 | <0.01 |
| show warnings | 903 | 16.1 | <0.01 |
| stmt send long data | 841 | 15 | <0.01 |
| show profiles | 704 | 12.6 | <0.01 |
| show create trigger | 456 | 8.1 | <0.01 |
| check | 386 | 6.9 | <0.01 |
| drop user | 310 | 5.5 | <0.01 |
| create user | 309 | 5.5 | <0.01 |
| show slave status | 304 | 5.4 | <0.01 |
| show binlog status | 301 | 5.4 | <0.01 |
| flush | 270 | 4.8 | <0.01 |
| create view | 141 | 2.5 | <0.01 |
| drop db | 113 | 2 | <0.01 |
| create db | 101 | 1.8 | <0.01 |
| show charsets | 101 | 1.8 | <0.01 |
| drop view | 76 | 1.4 | <0.01 |
| do | 45 | 0.8 | <0.01 |
| show triggers | 42 | 0.7 | <0.01 |
| show create proc | 38 | 0.7 | <0.01 |
| enable governor reconn lve | 17 | 0.3 | <0.01 |
| show create func | 16 | 0.3 | <0.01 |
| rollback | 11 | 0.2 | <0.01 |
| create temporary table | 6 | 0.1 | <0.01 |
| rename table | 4 | 0.1 | <0.01 |
| call procedure | 2 | <0.1 | <0.01 |