Statements | # | ø per hour | % |
---|---|---|---|
select | 4,111 M | 634.3 k | 62.96 |
begin | 483 M | 74.5 k | 7.40 |
commit | 483 M | 74.5 k | 7.39 |
update | 390 M | 60.2 k | 5.97 |
insert | 266 M | 41 k | 4.07 |
set option | 219 M | 33.9 k | 3.36 |
show fields | 107 M | 16.5 k | 1.64 |
create table | 79,642 k | 12.3 k | 1.22 |
change db | 71,815 k | 11.1 k | 1.10 |
delete | 68,905 k | 10.6 k | 1.06 |
show tables | 60,629 k | 9,354.4 | 0.93 |
show table status | 28,259 k | 4,360.1 | 0.43 |
show triggers | 28,113 k | 4,337.6 | 0.43 |
stmt prepare | 27,425 k | 4,231.3 | 0.42 |
stmt execute | 27,424 k | 4,231.2 | 0.42 |
stmt close | 27,422 k | 4,230.9 | 0.42 |
show create table | 14,814 k | 2,285.6 | 0.23 |
rollback to savepoint | 13,844 k | 2,135.9 | 0.21 |
show status | 3,109 k | 479.7 | 0.05 |
show variables | 2,910 k | 448.9 | 0.04 |
insert select | 2,202 k | 339.8 | 0.03 |
show slave status | 1,926 k | 297.1 | 0.03 |
replace | 1,856 k | 286.4 | 0.03 |
delete multi | 1,318 k | 203.3 | 0.02 |
unlock tables | 1,254 k | 193.5 | 0.02 |
lock tables | 1,011 k | 156 | 0.02 |
show binlogs | 972 k | 150 | 0.01 |
show slave hosts | 972 k | 150 | 0.01 |
alter table | 835 k | 128.8 | 0.01 |
show engine status | 788 k | 121.6 | 0.01 |
stmt send long data | 347 k | 53.6 | 0.01 |
show keys | 300 k | 46.2 | <0.01 |
savepoint | 239 k | 36.9 | <0.01 |
release savepoint | 239 k | 36.9 | <0.01 |
show function status | 238 k | 36.8 | <0.01 |
show procedure status | 238 k | 36.8 | <0.01 |
show events | 236 k | 36.5 | <0.01 |
show create db | 236 k | 36.5 | <0.01 |
drop table | 118 k | 18.3 | <0.01 |
update multi | 112 k | 17.3 | <0.01 |
truncate | 100 k | 15.5 | <0.01 |
show grants | 61,107 | 9.4 | <0.01 |
optimize | 55,038 | 8.5 | <0.01 |
show warnings | 51,884 | 8 | <0.01 |
do | 45,288 | 7 | <0.01 |
show errors | 27,174 | 4.2 | <0.01 |
alter user | 9,244 | 1.4 | <0.01 |
check | 8,998 | 1.4 | <0.01 |
grant | 4,722 | 0.7 | <0.01 |
revoke all | 4,302 | 0.7 | <0.01 |
show master status | 4,167 | 0.6 | <0.01 |
show databases | 2,116 | 0.3 | <0.01 |
show plugins | 1,281 | 0.2 | <0.01 |
checksum | 1,245 | 0.2 | <0.01 |
show storage engines | 1,232 | 0.2 | <0.01 |
show charsets | 1,165 | 0.2 | <0.01 |
show create func | 1,123 | 0.2 | <0.01 |
replace select | 718 | 0.1 | <0.01 |
purge | 609 | 0.1 | <0.01 |
revoke | 519 | 0.1 | <0.01 |
drop user | 419 | 0.1 | <0.01 |
load | 412 | 0.1 | <0.01 |
create user | 221 | <0.1 | <0.01 |
show collations | 119 | <0.1 | <0.01 |
drop db | 93 | <0.1 | <0.01 |
analyze | 82 | <0.1 | <0.01 |
rename table | 65 | <0.1 | <0.01 |
rollback | 60 | <0.1 | <0.01 |
create index | 56 | <0.1 | <0.01 |
show open tables | 40 | <0.1 | <0.01 |
repair | 38 | <0.1 | <0.01 |
kill | 30 | <0.1 | <0.01 |
flush | 27 | <0.1 | <0.01 |
drop index | 15 | <0.1 | <0.01 |
show processlist | 8 | <0.1 | <0.01 |
drop function | 6 | <0.1 | <0.01 |
create trigger | 3 | <0.1 | <0.01 |
create function | 3 | <0.1 | <0.01 |
slave stop | 3 | <0.1 | <0.01 |
reset | 3 | <0.1 | <0.01 |
slave start | 2 | <0.1 | <0.01 |
change master | 2 | <0.1 | <0.01 |
create db | 1 | <0.1 | <0.01 |