Statements | # | ø per hour | % |
---|---|---|---|
select | 3,885 M | 609.9 k | 61.97 |
begin | 483 M | 75.8 k | 7.70 |
commit | 483 M | 75.8 k | 7.70 |
update | 385 M | 60.5 k | 6.14 |
insert | 260 M | 40.9 k | 4.15 |
set option | 213 M | 33.5 k | 3.40 |
show fields | 105 M | 16.4 k | 1.67 |
create table | 75,393 k | 11.8 k | 1.20 |
change db | 69,031 k | 10.8 k | 1.10 |
delete | 67,360 k | 10.6 k | 1.07 |
show tables | 58,695 k | 9,213.5 | 0.94 |
show table status | 28,233 k | 4,431.8 | 0.45 |
show triggers | 28,094 k | 4,410 | 0.45 |
stmt prepare | 26,268 k | 4,123.3 | 0.42 |
stmt execute | 26,267 k | 4,123.2 | 0.42 |
stmt close | 26,265 k | 4,122.9 | 0.42 |
show create table | 14,774 k | 2,319.1 | 0.24 |
rollback to savepoint | 13,839 k | 2,172.4 | 0.22 |
show status | 2,968 k | 465.9 | 0.05 |
show variables | 2,863 k | 449.4 | 0.05 |
insert select | 2,092 k | 328.4 | 0.03 |
show slave status | 1,897 k | 297.8 | 0.03 |
replace | 1,793 k | 281.5 | 0.03 |
delete multi | 1,259 k | 197.7 | 0.02 |
unlock tables | 1,228 k | 192.8 | 0.02 |
lock tables | 985 k | 154.7 | 0.02 |
show binlogs | 956 k | 150 | 0.02 |
show slave hosts | 956 k | 150 | 0.02 |
alter table | 812 k | 127.5 | 0.01 |
show engine status | 775 k | 121.7 | 0.01 |
stmt send long data | 331 k | 52 | 0.01 |
show keys | 280 k | 44 | <0.01 |
savepoint | 239 k | 37.5 | <0.01 |
release savepoint | 239 k | 37.5 | <0.01 |
show function status | 238 k | 37.4 | <0.01 |
show procedure status | 238 k | 37.4 | <0.01 |
show events | 236 k | 37.1 | <0.01 |
show create db | 236 k | 37.1 | <0.01 |
drop table | 116 k | 18.3 | <0.01 |
update multi | 111 k | 17.4 | <0.01 |
truncate | 98,541 | 15.5 | <0.01 |
show grants | 60,263 | 9.5 | <0.01 |
optimize | 54,171 | 8.5 | <0.01 |
show warnings | 50,789 | 8 | <0.01 |
do | 42,080 | 6.6 | <0.01 |
show errors | 25,590 | 4 | <0.01 |
alter user | 9,174 | 1.4 | <0.01 |
check | 8,538 | 1.3 | <0.01 |
grant | 4,685 | 0.7 | <0.01 |
revoke all | 4,273 | 0.7 | <0.01 |
show master status | 3,916 | 0.6 | <0.01 |
show databases | 2,079 | 0.3 | <0.01 |
show storage engines | 1,135 | 0.2 | <0.01 |
show create func | 1,123 | 0.2 | <0.01 |
checksum | 1,106 | 0.2 | <0.01 |
show charsets | 1,103 | 0.2 | <0.01 |
replace select | 696 | 0.1 | <0.01 |
purge | 576 | 0.1 | <0.01 |
revoke | 509 | 0.1 | <0.01 |
show plugins | 484 | 0.1 | <0.01 |
drop user | 411 | 0.1 | <0.01 |
load | 398 | 0.1 | <0.01 |
create user | 217 | <0.1 | <0.01 |
show collations | 107 | <0.1 | <0.01 |
drop db | 93 | <0.1 | <0.01 |
analyze | 81 | <0.1 | <0.01 |
rename table | 64 | <0.1 | <0.01 |
create index | 56 | <0.1 | <0.01 |
rollback | 55 | <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 | 6 | <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 |