
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 1,096 M | 1,302 k | 84.48 |
| set option | 37,865 k | 45 k | 2.92 |
| update | 24,529 k | 29.1 k | 1.89 |
| insert | 22,178 k | 26.3 k | 1.71 |
| begin | 21,327 k | 25.3 k | 1.64 |
| commit | 21,170 k | 25.1 k | 1.63 |
| show fields | 15,643 k | 18.6 k | 1.21 |
| change db | 15,398 k | 18.3 k | 1.19 |
| delete | 10,471 k | 12.4 k | 0.81 |
| stmt execute | 6,421 k | 7,624.5 | 0.49 |
| stmt prepare | 6,383 k | 7,579.4 | 0.49 |
| stmt close | 6,380 k | 7,576.2 | 0.49 |
| show tables | 3,973 k | 4,718.4 | 0.31 |
| show table status | 1,784 k | 2,118.1 | 0.14 |
| show triggers | 1,758 k | 2,087.7 | 0.14 |
| show status | 1,582 k | 1,878.5 | 0.12 |
| show create table | 943 k | 1,119.8 | 0.07 |
| rollback to savepoint | 906 k | 1,075.7 | 0.07 |
| update multi | 392 k | 466.1 | 0.03 |
| delete multi | 373 k | 442.4 | 0.03 |
| show variables | 296 k | 351 | 0.02 |
| insert select | 256 k | 303.8 | 0.02 |
| show slave status | 236 k | 279.7 | 0.02 |
| rollback | 157 k | 185.9 | 0.01 |
| show binlogs | 127 k | 151 | 0.01 |
| show slave hosts | 126 k | 150 | 0.01 |
| show engine status | 102 k | 121.4 | 0.01 |
| replace | 102 k | 121.4 | 0.01 |
| unlock tables | 79,254 | 94.1 | 0.01 |
| stmt send long data | 63,202 | 75.1 | <0.01 |
| lock tables | 63,122 | 75 | <0.01 |
| do | 44,888 | 53.3 | <0.01 |
| show keys | 35,894 | 42.6 | <0.01 |
| create table | 34,698 | 41.2 | <0.01 |
| show charsets | 27,477 | 32.6 | <0.01 |
| drop table | 19,977 | 23.7 | <0.01 |
| show errors | 16,103 | 19.1 | <0.01 |
| show function status | 15,597 | 18.5 | <0.01 |
| show procedure status | 15,595 | 18.5 | <0.01 |
| release savepoint | 15,465 | 18.4 | <0.01 |
| savepoint | 15,465 | 18.4 | <0.01 |
| show events | 15,439 | 18.3 | <0.01 |
| show create db | 14,869 | 17.7 | <0.01 |
| show grants | 14,270 | 16.9 | <0.01 |
| truncate | 9,555 | 11.3 | <0.01 |
| alter table | 9,257 | 11 | <0.01 |
| alter user | 2,642 | 3.1 | <0.01 |
| optimize | 2,327 | 2.8 | <0.01 |
| show plugins | 2,055 | 2.4 | <0.01 |
| grant | 1,522 | 1.8 | <0.01 |
| show warnings | 1,466 | 1.7 | <0.01 |
| show master status | 1,215 | 1.4 | <0.01 |
| revoke all | 1,035 | 1.2 | <0.01 |
| checksum | 846 | 1 | <0.01 |
| show databases | 756 | 0.9 | <0.01 |
| show create trigger | 672 | 0.8 | <0.01 |
| revoke | 521 | 0.6 | <0.01 |
| show storage engines | 391 | 0.5 | <0.01 |
| drop user | 324 | 0.4 | <0.01 |
| empty query | 316 | 0.4 | <0.01 |
| create user | 241 | 0.3 | <0.01 |
| purge | 144 | 0.2 | <0.01 |
| show create func | 143 | 0.2 | <0.01 |
| show collations | 104 | 0.1 | <0.01 |
| drop db | 44 | 0.1 | <0.01 |
| rename table | 34 | <0.1 | <0.01 |
| create index | 32 | <0.1 | <0.01 |
| show processlist | 11 | <0.1 | <0.01 |
| flush | 5 | <0.1 | <0.01 |
| create db | 3 | <0.1 | <0.01 |
| repair | 2 | <0.1 | <0.01 |
| reset | 1 | <0.1 | <0.01 |
| slave stop | 1 | <0.1 | <0.01 |