Statements | # | ø per hour | % |
---|---|---|---|
select | 1,789 M | 1,380.1 k | 80.27 |
set option | 64,971 k | 50.1 k | 2.92 |
insert | 62,532 k | 48.2 k | 2.81 |
update | 60,616 k | 46.8 k | 2.72 |
create table | 43,858 k | 33.8 k | 1.97 |
commit | 35,122 k | 27.1 k | 1.58 |
begin | 35,114 k | 27.1 k | 1.58 |
show fields | 25,440 k | 19.6 k | 1.14 |
change db | 22,884 k | 17.7 k | 1.03 |
delete | 18,252 k | 14.1 k | 0.82 |
show tables | 15,295 k | 11.8 k | 0.69 |
stmt prepare | 13,540 k | 10.4 k | 0.61 |
stmt execute | 13,539 k | 10.4 k | 0.61 |
stmt close | 13,538 k | 10.4 k | 0.61 |
show table status | 2,494 k | 1,924.3 | 0.11 |
show triggers | 2,431 k | 1,875.7 | 0.11 |
show create table | 1,574 k | 1,213.9 | 0.07 |
show status | 1,362 k | 1,050.9 | 0.06 |
rollback to savepoint | 1,116 k | 861.2 | 0.05 |
insert select | 1,015 k | 782.9 | 0.05 |
replace | 685 k | 528.8 | 0.03 |
unlock tables | 647 k | 499 | 0.03 |
show variables | 647 k | 498.7 | 0.03 |
lock tables | 627 k | 483.7 | 0.03 |
delete multi | 576 k | 444.7 | 0.03 |
show slave status | 354 k | 273.3 | 0.02 |
alter table | 255 k | 196.8 | 0.01 |
show keys | 201 k | 154.9 | 0.01 |
show binlogs | 195 k | 150.1 | 0.01 |
show slave hosts | 194 k | 150 | 0.01 |
stmt send long data | 172 k | 132.3 | 0.01 |
show engine status | 157 k | 121.3 | 0.01 |
show grants | 56,382 | 43.5 | <0.01 |
show warnings | 53,668 | 41.4 | <0.01 |
do | 25,799 | 19.9 | <0.01 |
drop table | 24,412 | 18.8 | <0.01 |
truncate | 20,253 | 15.6 | <0.01 |
savepoint | 19,523 | 15.1 | <0.01 |
release savepoint | 19,523 | 15.1 | <0.01 |
show function status | 19,274 | 14.9 | <0.01 |
show procedure status | 19,272 | 14.9 | <0.01 |
show create db | 18,402 | 14.2 | <0.01 |
show events | 18,402 | 14.2 | <0.01 |
show errors | 12,428 | 9.6 | <0.01 |
update multi | 11,213 | 8.6 | <0.01 |
optimize | 10,561 | 8.1 | <0.01 |
check | 4,283 | 3.3 | <0.01 |
load | 4,204 | 3.2 | <0.01 |
alter user | 2,360 | 1.8 | <0.01 |
show master status | 1,927 | 1.5 | <0.01 |
grant | 1,213 | 0.9 | <0.01 |
revoke all | 1,103 | 0.9 | <0.01 |
show databases | 1,085 | 0.8 | <0.01 |
show charsets | 541 | 0.4 | <0.01 |
checksum | 534 | 0.4 | <0.01 |
replace select | 392 | 0.3 | <0.01 |
purge | 275 | 0.2 | <0.01 |
revoke | 127 | 0.1 | <0.01 |
show create func | 94 | 0.1 | <0.01 |
drop user | 94 | 0.1 | <0.01 |
show plugins | 83 | 0.1 | <0.01 |
show collations | 65 | 0.1 | <0.01 |
create user | 60 | <0.1 | <0.01 |
rollback | 42 | <0.1 | <0.01 |
show storage engines | 25 | <0.1 | <0.01 |
create index | 20 | <0.1 | <0.01 |
drop db | 20 | <0.1 | <0.01 |
rename table | 15 | <0.1 | <0.01 |
analyze | 10 | <0.1 | <0.01 |
repair | 8 | <0.1 | <0.01 |
drop index | 7 | <0.1 | <0.01 |
drop function | 4 | <0.1 | <0.01 |
create function | 2 | <0.1 | <0.01 |
show processlist | 2 | <0.1 | <0.01 |
create trigger | 2 | <0.1 | <0.01 |
show open tables | 2 | <0.1 | <0.01 |
reset | 1 | <0.1 | <0.01 |
empty query | 1 | <0.1 | <0.01 |
slave stop | 1 | <0.1 | <0.01 |