Statements | # | ø per hour | % |
---|---|---|---|
select | 2,149 M | 1,695.2 k | 92.87 |
set option | 37,856 k | 29.9 k | 1.64 |
insert | 26,047 k | 20.5 k | 1.13 |
update | 25,049 k | 19.8 k | 1.08 |
change db | 16,768 k | 13.2 k | 0.72 |
show fields | 13,447 k | 10.6 k | 0.58 |
show tables | 9,207 k | 7,262.5 | 0.40 |
delete | 8,353 k | 6,589.1 | 0.36 |
stmt execute | 4,622 k | 3,646.1 | 0.20 |
stmt prepare | 4,622 k | 3,646.1 | 0.20 |
stmt close | 4,613 k | 3,638.8 | 0.20 |
commit | 3,147 k | 2,482.4 | 0.14 |
begin | 3,113 k | 2,456 | 0.13 |
replace | 1,921 k | 1,515.2 | 0.08 |
show status | 1,704 k | 1,344.5 | 0.07 |
create table | 1,488 k | 1,174.2 | 0.06 |
delete multi | 708 k | 558.3 | 0.03 |
show variables | 383 k | 302.2 | 0.02 |
show slave status | 327 k | 258.2 | 0.01 |
insert select | 196 k | 154.3 | 0.01 |
show binlogs | 192 k | 151.2 | 0.01 |
show slave hosts | 190 k | 150 | 0.01 |
show engine status | 153 k | 121 | 0.01 |
show create table | 130 k | 102.2 | 0.01 |
show keys | 114 k | 89.9 | <0.01 |
stmt send long data | 109 k | 85.6 | <0.01 |
show table status | 104 k | 81.7 | <0.01 |
show triggers | 82,250 | 64.9 | <0.01 |
rollback to savepoint | 81,457 | 64.3 | <0.01 |
do | 53,286 | 42 | <0.01 |
show charsets | 46,166 | 36.4 | <0.01 |
show warnings | 45,270 | 35.7 | <0.01 |
show grants | 40,042 | 31.6 | <0.01 |
alter table | 27,724 | 21.9 | <0.01 |
drop table | 14,512 | 11.4 | <0.01 |
truncate | 12,751 | 10.1 | <0.01 |
show plugins | 7,627 | 6 | <0.01 |
show errors | 7,336 | 5.8 | <0.01 |
unlock tables | 6,421 | 5.1 | <0.01 |
lock tables | 4,833 | 3.8 | <0.01 |
show master status | 3,072 | 2.4 | <0.01 |
optimize | 2,866 | 2.3 | <0.01 |
show procedure status | 1,981 | 1.6 | <0.01 |
show function status | 1,981 | 1.6 | <0.01 |
checksum | 1,714 | 1.4 | <0.01 |
release savepoint | 1,698 | 1.3 | <0.01 |
savepoint | 1,698 | 1.3 | <0.01 |
show events | 1,698 | 1.3 | <0.01 |
show storage engines | 1,535 | 1.2 | <0.01 |
show create db | 644 | 0.5 | <0.01 |
alter user | 486 | 0.4 | <0.01 |
empty query | 472 | 0.4 | <0.01 |
update multi | 435 | 0.3 | <0.01 |
grant | 245 | 0.2 | <0.01 |
replace select | 220 | 0.2 | <0.01 |
show collations | 216 | 0.2 | <0.01 |
show databases | 208 | 0.2 | <0.01 |
revoke all | 193 | 0.2 | <0.01 |
drop user | 63 | <0.1 | <0.01 |
revoke | 62 | <0.1 | <0.01 |
show processlist | 38 | <0.1 | <0.01 |
create user | 37 | <0.1 | <0.01 |
purge | 20 | <0.1 | <0.01 |
drop db | 14 | <0.1 | <0.01 |
flush | 9 | <0.1 | <0.01 |
create db | 6 | <0.1 | <0.01 |
show create func | 4 | <0.1 | <0.01 |
repair | 4 | <0.1 | <0.01 |
rollback | 2 | <0.1 | <0.01 |
slave stop | 1 | <0.1 | <0.01 |
create index | 1 | <0.1 | <0.01 |
reset | 1 | <0.1 | <0.01 |