| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 766 M | 13.6 M | 92.09 |
| stmt prepare | 11,676 k | 207 k | 1.40 |
| stmt execute | 11,671 k | 206.9 k | 1.40 |
| stmt close | 11,671 k | 206.9 k | 1.40 |
| set option | 11,197 k | 198.5 k | 1.35 |
| update | 6,295 k | 111.6 k | 0.76 |
| change db | 3,607 k | 63.9 k | 0.43 |
| insert | 3,503 k | 62.1 k | 0.42 |
| show fields | 2,384 k | 42.3 k | 0.29 |
| delete | 832 k | 14.7 k | 0.10 |
| replace | 777 k | 13.8 k | 0.09 |
| show tables | 776 k | 13.8 k | 0.09 |
| show status | 315 k | 5,589.5 | 0.04 |
| show variables | 218 k | 3,871.1 | 0.03 |
| show engine status | 203 k | 3,599.5 | 0.02 |
| show generic | 203 k | 3,599.2 | 0.02 |
| insert select | 187 k | 3,311.9 | 0.02 |
| update multi | 65,833 | 1,167.2 | 0.01 |
| show processlist | 54,834 | 972.2 | 0.01 |
| show keys | 39,925 | 707.9 | <0.01 |
| show create table | 26,092 | 462.6 | <0.01 |
| rollback to savepoint | 25,570 | 453.3 | <0.01 |
| alter table | 22,789 | 404 | <0.01 |
| create table | 15,801 | 280.1 | <0.01 |
| show profile | 14,873 | 263.7 | <0.01 |
| delete multi | 9,277 | 164.5 | <0.01 |
| begin | 8,381 | 148.6 | <0.01 |
| commit | 7,568 | 134.2 | <0.01 |
| show databases | 5,041 | 89.4 | <0.01 |
| show warnings | 4,499 | 79.8 | <0.01 |
| truncate | 3,662 | 64.9 | <0.01 |
| show grants | 3,657 | 64.8 | <0.01 |
| savepoint | 3,527 | 62.5 | <0.01 |
| enable governor lve | 3,383 | 60 | <0.01 |
| show table status | 1,427 | 25.3 | <0.01 |
| stmt send long data | 1,210 | 21.5 | <0.01 |
| unlock tables | 1,118 | 19.8 | <0.01 |
| show profiles | 1,027 | 18.2 | <0.01 |
| show storage engines | 1,010 | 17.9 | <0.01 |
| empty query | 947 | 16.8 | <0.01 |
| release savepoint | 810 | 14.4 | <0.01 |
| alter user | 695 | 12.3 | <0.01 |
| show function status | 432 | 7.7 | <0.01 |
| show procedure status | 432 | 7.7 | <0.01 |
| show events | 415 | 7.4 | <0.01 |
| show package status | 408 | 7.2 | <0.01 |
| show package body status | 408 | 7.2 | <0.01 |
| show create db | 403 | 7.1 | <0.01 |
| show binlogs | 371 | 6.6 | <0.01 |
| grant | 325 | 5.8 | <0.01 |
| lock tables | 306 | 5.4 | <0.01 |
| drop table | 305 | 5.4 | <0.01 |
| show slave status | 145 | 2.6 | <0.01 |
| show binlog status | 143 | 2.5 | <0.01 |
| show create trigger | 125 | 2.2 | <0.01 |
| check | 56 | 1 | <0.01 |
| create view | 50 | 0.9 | <0.01 |
| flush | 33 | 0.6 | <0.01 |
| create user | 21 | 0.4 | <0.01 |
| drop user | 19 | 0.3 | <0.01 |
| do | 18 | 0.3 | <0.01 |
| show triggers | 17 | 0.3 | <0.01 |
| drop db | 8 | 0.1 | <0.01 |
| create db | 7 | 0.1 | <0.01 |
| create temporary table | 6 | 0.1 | <0.01 |
| show charsets | 5 | 0.1 | <0.01 |
| call procedure | 2 | <0.1 | <0.01 |
| rollback | 2 | <0.1 | <0.01 |
| enable governor reconn lve | 1 | <0.1 | <0.01 |