| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 379 M | 4,842.1 k | 87.25 |
| stmt execute | 9,316 k | 118.9 k | 2.14 |
| stmt prepare | 9,300 k | 118.7 k | 2.14 |
| stmt close | 9,299 k | 118.7 k | 2.14 |
| set option | 7,528 k | 96.1 k | 1.73 |
| insert | 4,180 k | 53.3 k | 0.96 |
| update | 4,058 k | 51.8 k | 0.93 |
| change db | 2,223 k | 28.4 k | 0.51 |
| delete | 2,180 k | 27.8 k | 0.50 |
| show fields | 1,885 k | 24 k | 0.43 |
| show tables | 1,422 k | 18.1 k | 0.33 |
| show keys | 1,062 k | 13.6 k | 0.24 |
| show variables | 713 k | 9,094.4 | 0.16 |
| show create table | 297 k | 3,789.6 | 0.07 |
| show status | 288 k | 3,673.7 | 0.07 |
| show engine status | 282 k | 3,599.5 | 0.06 |
| show generic | 282 k | 3,599.5 | 0.06 |
| show grants | 218 k | 2,778.3 | 0.05 |
| show warnings | 210 k | 2,676.8 | 0.05 |
| replace | 117 k | 1,486.7 | 0.03 |
| insert select | 101 k | 1,288.1 | 0.02 |
| update multi | 90,939 | 1,160.5 | 0.02 |
| alter table | 80,661 | 1,029.4 | 0.02 |
| show processlist | 76,181 | 972.2 | 0.02 |
| rollback to savepoint | 60,870 | 776.8 | 0.01 |
| repair | 45,221 | 577.1 | 0.01 |
| create table | 30,654 | 391.2 | 0.01 |
| begin | 14,402 | 183.8 | <0.01 |
| commit | 12,744 | 162.6 | <0.01 |
| show databases | 12,173 | 155.3 | <0.01 |
| delete multi | 8,576 | 109.4 | <0.01 |
| empty query | 5,237 | 66.8 | <0.01 |
| enable governor lve | 4,697 | 59.9 | <0.01 |
| alter user | 4,009 | 51.2 | <0.01 |
| show table status | 3,326 | 42.4 | <0.01 |
| unlock tables | 3,069 | 39.2 | <0.01 |
| grant | 2,543 | 32.5 | <0.01 |
| savepoint | 1,633 | 20.8 | <0.01 |
| release savepoint | 1,612 | 20.6 | <0.01 |
| lock tables | 1,407 | 18 | <0.01 |
| check | 1,168 | 14.9 | <0.01 |
| show function status | 844 | 10.8 | <0.01 |
| show procedure status | 844 | 10.8 | <0.01 |
| stmt send long data | 844 | 10.8 | <0.01 |
| show events | 824 | 10.5 | <0.01 |
| show create db | 806 | 10.3 | <0.01 |
| show package status | 806 | 10.3 | <0.01 |
| show package body status | 806 | 10.3 | <0.01 |
| truncate | 432 | 5.5 | <0.01 |
| drop table | 429 | 5.5 | <0.01 |
| flush | 334 | 4.3 | <0.01 |
| show binlogs | 326 | 4.2 | <0.01 |
| show create trigger | 292 | 3.7 | <0.01 |
| show slave status | 211 | 2.7 | <0.01 |
| show binlog status | 208 | 2.7 | <0.01 |
| create user | 118 | 1.5 | <0.01 |
| do | 115 | 1.5 | <0.01 |
| show storage engines | 101 | 1.3 | <0.01 |
| drop user | 96 | 1.2 | <0.01 |
| rollback | 55 | 0.7 | <0.01 |
| show create proc | 48 | 0.6 | <0.01 |
| create view | 46 | 0.6 | <0.01 |
| create db | 43 | 0.5 | <0.01 |
| drop db | 39 | 0.5 | <0.01 |
| show triggers | 38 | 0.5 | <0.01 |
| show create func | 35 | 0.4 | <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 |