| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 87,825 k | 14.9 M | 87.69 |
| stmt prepare | 2,761 k | 468.8 k | 2.76 |
| stmt execute | 2,760 k | 468.5 k | 2.76 |
| stmt close | 2,760 k | 468.5 k | 2.76 |
| set option | 1,538 k | 261.2 k | 1.54 |
| update | 782 k | 132.7 k | 0.78 |
| change db | 540 k | 91.6 k | 0.54 |
| insert | 397 k | 67.4 k | 0.40 |
| show fields | 344 k | 58.4 k | 0.34 |
| delete | 96,391 | 16.4 k | 0.10 |
| show tables | 87,418 | 14.8 k | 0.09 |
| replace | 83,720 | 14.2 k | 0.08 |
| show status | 65,112 | 11.1 k | 0.07 |
| show variables | 22,944 | 3,895 | 0.02 |
| show engine status | 21,208 | 3,600.3 | 0.02 |
| show generic | 21,205 | 3,599.8 | 0.02 |
| insert select | 19,187 | 3,257.2 | 0.02 |
| update multi | 7,736 | 1,313.3 | 0.01 |
| show keys | 7,137 | 1,211.6 | 0.01 |
| show processlist | 5,729 | 972.6 | 0.01 |
| create table | 1,728 | 293.4 | <0.01 |
| delete multi | 1,429 | 242.6 | <0.01 |
| show profile | 1,375 | 233.4 | <0.01 |
| show create table | 1,250 | 212.2 | <0.01 |
| alter table | 1,143 | 194 | <0.01 |
| begin | 784 | 133.1 | <0.01 |
| commit | 774 | 131.4 | <0.01 |
| show databases | 610 | 103.6 | <0.01 |
| truncate | 402 | 68.2 | <0.01 |
| enable governor lve | 354 | 60.1 | <0.01 |
| show warnings | 340 | 57.7 | <0.01 |
| show storage engines | 298 | 50.6 | <0.01 |
| show grants | 271 | 46 | <0.01 |
| rollback to savepoint | 262 | 44.5 | <0.01 |
| unlock tables | 115 | 19.5 | <0.01 |
| drop table | 107 | 18.2 | <0.01 |
| lock tables | 105 | 17.8 | <0.01 |
| show profiles | 88 | 14.9 | <0.01 |
| show table status | 59 | 10 | <0.01 |
| stmt send long data | 59 | 10 | <0.01 |
| show binlog status | 38 | 6.5 | <0.01 |
| show slave status | 38 | 6.5 | <0.01 |
| show binlogs | 36 | 6.1 | <0.01 |
| grant | 34 | 5.8 | <0.01 |
| check | 28 | 4.8 | <0.01 |
| create view | 20 | 3.4 | <0.01 |
| empty query | 15 | 2.5 | <0.01 |
| release savepoint | 10 | 1.7 | <0.01 |
| savepoint | 10 | 1.7 | <0.01 |
| create user | 9 | 1.5 | <0.01 |
| show function status | 7 | 1.2 | <0.01 |
| show procedure status | 7 | 1.2 | <0.01 |
| do | 6 | 1 | <0.01 |
| drop user | 6 | 1 | <0.01 |
| create temporary table | 5 | 0.8 | <0.01 |
| flush | 5 | 0.8 | <0.01 |
| show create db | 5 | 0.8 | <0.01 |
| show events | 5 | 0.8 | <0.01 |
| show package status | 5 | 0.8 | <0.01 |
| show package body status | 5 | 0.8 | <0.01 |
| alter user | 4 | 0.7 | <0.01 |
| create db | 3 | 0.5 | <0.01 |
| drop db | 2 | 0.3 | <0.01 |
| show charsets | 2 | 0.3 | <0.01 |
| show triggers | 2 | 0.3 | <0.01 |
| alter db | 1 | 0.2 | <0.01 |