Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 636 M | 14.6 M | 92.95 |
| set option | 10,438 k | 239.6 k | 1.53 |
| stmt prepare | 6,927 k | 159 k | 1.01 |
| stmt execute | 6,926 k | 159 k | 1.01 |
| stmt close | 6,921 k | 158.9 k | 1.01 |
| update | 6,006 k | 137.9 k | 0.88 |
| change db | 3,320 k | 76.2 k | 0.49 |
| show fields | 2,446 k | 56.2 k | 0.36 |
| insert | 2,027 k | 46.5 k | 0.30 |
| show tables | 761 k | 17.5 k | 0.11 |
| delete | 711 k | 16.3 k | 0.10 |
| show status | 362 k | 8,305.6 | 0.05 |
| replace | 258 k | 5,923.7 | 0.04 |
| show variables | 162 k | 3,725.3 | 0.02 |
| show engine status | 157 k | 3,598.9 | 0.02 |
| show generic | 157 k | 3,598.9 | 0.02 |
| insert select | 144 k | 3,307.4 | 0.02 |
| show create table | 110 k | 2,519.2 | 0.02 |
| repair | 70,281 | 1,613.3 | 0.01 |
| rollback to savepoint | 55,200 | 1,267.1 | 0.01 |
| update multi | 54,716 | 1,256 | 0.01 |
| show databases | 53,877 | 1,236.8 | 0.01 |
| show processlist | 42,346 | 972.1 | 0.01 |
| alter table | 23,652 | 542.9 | <0.01 |
| create table | 15,735 | 361.2 | <0.01 |
| show keys | 11,515 | 264.3 | <0.01 |
| begin | 9,810 | 225.2 | <0.01 |
| delete multi | 8,131 | 186.6 | <0.01 |
| commit | 8,068 | 185.2 | <0.01 |
| show grants | 8,005 | 183.8 | <0.01 |
| show profile | 7,468 | 171.4 | <0.01 |
| savepoint | 6,963 | 159.8 | <0.01 |
| unlock tables | 5,399 | 123.9 | <0.01 |
| lock tables | 3,613 | 82.9 | <0.01 |
| truncate | 2,803 | 64.3 | <0.01 |
| enable governor lve | 2,606 | 59.8 | <0.01 |
| show table status | 2,385 | 54.7 | <0.01 |
| drop table | 2,321 | 53.3 | <0.01 |
| empty query | 2,001 | 45.9 | <0.01 |
| release savepoint | 1,734 | 39.8 | <0.01 |
| alter user | 1,264 | 29 | <0.01 |
| grant | 1,221 | 28 | <0.01 |
| show function status | 911 | 20.9 | <0.01 |
| show procedure status | 911 | 20.9 | <0.01 |
| show events | 891 | 20.5 | <0.01 |
| show package status | 869 | 19.9 | <0.01 |
| show package body status | 869 | 19.9 | <0.01 |
| show create db | 865 | 19.9 | <0.01 |
| stmt send long data | 601 | 13.8 | <0.01 |
| show profiles | 465 | 10.7 | <0.01 |
| show binlogs | 398 | 9.1 | <0.01 |
| show create trigger | 376 | 8.6 | <0.01 |
| check | 358 | 8.2 | <0.01 |
| drop user | 262 | 6 | <0.01 |
| create user | 261 | 6 | <0.01 |
| flush | 234 | 5.4 | <0.01 |
| show storage engines | 214 | 4.9 | <0.01 |
| show warnings | 188 | 4.3 | <0.01 |
| show slave status | 146 | 3.4 | <0.01 |
| show binlog status | 144 | 3.3 | <0.01 |
| create view | 116 | 2.7 | <0.01 |
| drop db | 97 | 2.2 | <0.01 |
| create db | 85 | 2 | <0.01 |
| show charsets | 85 | 2 | <0.01 |
| drop view | 76 | 1.7 | <0.01 |
| show triggers | 39 | 0.9 | <0.01 |
| do | 36 | 0.8 | <0.01 |
| show create proc | 19 | 0.4 | <0.01 |
| enable governor reconn lve | 17 | 0.4 | <0.01 |
| show create func | 15 | 0.3 | <0.01 |
| rollback | 7 | 0.2 | <0.01 |
| create temporary table | 4 | 0.1 | <0.01 |
| rename table | 4 | 0.1 | <0.01 |
| call procedure | 1 | <0.1 | <0.01 |