Console
| Statements | # | ø per hour | % |
|---|---|---|---|
| select | 2,248 M | 11.9 M | 92.20 |
| set option | 30,791 k | 162.5 k | 1.26 |
| stmt execute | 25,216 k | 133.1 k | 1.03 |
| update | 25,202 k | 133 k | 1.03 |
| stmt prepare | 25,103 k | 132.5 k | 1.03 |
| stmt close | 25,102 k | 132.5 k | 1.03 |
| replace | 22,705 k | 119.8 k | 0.93 |
| change db | 9,449 k | 49.9 k | 0.39 |
| show fields | 8,555 k | 45.1 k | 0.35 |
| insert | 6,584 k | 34.7 k | 0.27 |
| delete | 2,534 k | 13.4 k | 0.10 |
| show status | 2,310 k | 12.2 k | 0.09 |
| show tables | 1,867 k | 9,852.7 | 0.08 |
| show variables | 782 k | 4,128.7 | 0.03 |
| insert select | 703 k | 3,707.4 | 0.03 |
| show engine status | 682 k | 3,599.8 | 0.03 |
| show generic | 682 k | 3,599.7 | 0.03 |
| show keys | 241 k | 1,273.9 | 0.01 |
| show create table | 204 k | 1,076.6 | 0.01 |
| show processlist | 184 k | 972.2 | 0.01 |
| update multi | 152 k | 803.5 | 0.01 |
| rollback to savepoint | 152 k | 800.4 | 0.01 |
| show databases | 143 k | 756.5 | 0.01 |
| call procedure | 83,101 | 438.5 | <0.01 |
| delete multi | 78,910 | 416.4 | <0.01 |
| create table | 72,254 | 381.3 | <0.01 |
| repair | 65,759 | 347 | <0.01 |
| drop table | 61,259 | 323.3 | <0.01 |
| create temporary table | 58,224 | 307.2 | <0.01 |
| alter table | 57,818 | 305.1 | <0.01 |
| begin | 50,539 | 266.7 | <0.01 |
| show warnings | 38,880 | 205.2 | <0.01 |
| show profile | 38,599 | 203.7 | <0.01 |
| commit | 25,916 | 136.8 | <0.01 |
| rollback | 20,626 | 108.8 | <0.01 |
| show grants | 12,773 | 67.4 | <0.01 |
| enable governor lve | 11,359 | 59.9 | <0.01 |
| unlock tables | 8,096 | 42.7 | <0.01 |
| show table status | 5,990 | 31.6 | <0.01 |
| truncate | 5,452 | 28.8 | <0.01 |
| savepoint | 4,114 | 21.7 | <0.01 |
| release savepoint | 4,090 | 21.6 | <0.01 |
| empty query | 4,027 | 21.3 | <0.01 |
| lock tables | 3,963 | 20.9 | <0.01 |
| grant | 3,732 | 19.7 | <0.01 |
| alter user | 2,775 | 14.6 | <0.01 |
| stmt send long data | 2,616 | 13.8 | <0.01 |
| show storage engines | 2,523 | 13.3 | <0.01 |
| show profiles | 2,473 | 13 | <0.01 |
| show function status | 2,131 | 11.2 | <0.01 |
| show procedure status | 2,130 | 11.2 | <0.01 |
| show events | 2,095 | 11.1 | <0.01 |
| show package status | 2,049 | 10.8 | <0.01 |
| show package body status | 2,049 | 10.8 | <0.01 |
| show create db | 2,041 | 10.8 | <0.01 |
| check | 1,801 | 9.5 | <0.01 |
| show create trigger | 459 | 2.4 | <0.01 |
| show slave status | 445 | 2.3 | <0.01 |
| show binlog status | 439 | 2.3 | <0.01 |
| create user | 324 | 1.7 | <0.01 |
| flush | 299 | 1.6 | <0.01 |
| show binlogs | 151 | 0.8 | <0.01 |
| create view | 143 | 0.8 | <0.01 |
| drop user | 137 | 0.7 | <0.01 |
| show triggers | 120 | 0.6 | <0.01 |
| do | 90 | 0.5 | <0.01 |
| create db | 89 | 0.5 | <0.01 |
| create index | 80 | 0.4 | <0.01 |
| show charsets | 56 | 0.3 | <0.01 |
| revoke | 55 | 0.3 | <0.01 |
| drop db | 53 | 0.3 | <0.01 |
| show create proc | 31 | 0.2 | <0.01 |
| drop temporary table | 27 | 0.1 | <0.01 |
| enable governor reconn lve | 27 | 0.1 | <0.01 |
| alter db | 24 | 0.1 | <0.01 |
| show create func | 23 | 0.1 | <0.01 |
| create trigger | 14 | 0.1 | <0.01 |
| drop trigger | 4 | <0.1 | <0.01 |
| create procedure | 2 | <0.1 | <0.01 |
| drop index | 2 | <0.1 | <0.01 |
| drop procedure | 2 | <0.1 | <0.01 |
| rename table | 2 | <0.1 | <0.01 |