Statements | # | ø per hour | % |
---|---|---|---|
select | 2,017 M | 1,441.4 k | 80.66 |
set option | 72,157 k | 51.6 k | 2.89 |
insert | 69,070 k | 49.4 k | 2.76 |
update | 66,855 k | 47.8 k | 2.67 |
create table | 48,454 k | 34.6 k | 1.94 |
commit | 35,192 k | 25.2 k | 1.41 |
begin | 35,182 k | 25.1 k | 1.41 |
show fields | 27,871 k | 19.9 k | 1.11 |
change db | 26,540 k | 19 k | 1.06 |
delete | 19,671 k | 14.1 k | 0.79 |
show tables | 17,095 k | 12.2 k | 0.68 |
stmt prepare | 16,545 k | 11.8 k | 0.66 |
stmt execute | 16,544 k | 11.8 k | 0.66 |
stmt close | 16,543 k | 11.8 k | 0.66 |
show table status | 2,519 k | 1,800.3 | 0.10 |
show triggers | 2,449 k | 1,750.6 | 0.10 |
show create table | 1,609 k | 1,150.2 | 0.06 |
show status | 1,491 k | 1,065.6 | 0.06 |
rollback to savepoint | 1,121 k | 801.2 | 0.04 |
insert select | 1,117 k | 798.7 | 0.04 |
replace | 837 k | 598 | 0.03 |
show variables | 706 k | 504.7 | 0.03 |
unlock tables | 676 k | 483 | 0.03 |
lock tables | 656 k | 468.8 | 0.03 |
delete multi | 636 k | 454.4 | 0.03 |
show slave status | 381 k | 272.2 | 0.02 |
alter table | 333 k | 238.3 | 0.01 |
show keys | 245 k | 175.2 | 0.01 |
show binlogs | 210 k | 150.2 | 0.01 |
show slave hosts | 210 k | 150 | 0.01 |
stmt send long data | 192 k | 137.3 | 0.01 |
show engine status | 170 k | 121.3 | 0.01 |
show grants | 57,391 | 41 | <0.01 |
show warnings | 54,155 | 38.7 | <0.01 |
do | 29,118 | 20.8 | <0.01 |
drop table | 26,161 | 18.7 | <0.01 |
truncate | 21,830 | 15.6 | <0.01 |
savepoint | 19,647 | 14 | <0.01 |
release savepoint | 19,647 | 14 | <0.01 |
show function status | 19,367 | 13.8 | <0.01 |
show procedure status | 19,365 | 13.8 | <0.01 |
show events | 18,402 | 13.2 | <0.01 |
show create db | 18,402 | 13.2 | <0.01 |
show errors | 13,884 | 9.9 | <0.01 |
update multi | 13,157 | 9.4 | <0.01 |
optimize | 11,382 | 8.1 | <0.01 |
check | 4,691 | 3.4 | <0.01 |
load | 4,298 | 3.1 | <0.01 |
alter user | 2,544 | 1.8 | <0.01 |
show master status | 2,169 | 1.6 | <0.01 |
grant | 1,304 | 0.9 | <0.01 |
revoke all | 1,190 | 0.9 | <0.01 |
show databases | 1,182 | 0.8 | <0.01 |
show charsets | 611 | 0.4 | <0.01 |
checksum | 585 | 0.4 | <0.01 |
replace select | 444 | 0.3 | <0.01 |
purge | 310 | 0.2 | <0.01 |
revoke | 133 | 0.1 | <0.01 |
show plugins | 106 | 0.1 | <0.01 |
drop user | 101 | 0.1 | <0.01 |
show create func | 94 | 0.1 | <0.01 |
show collations | 73 | 0.1 | <0.01 |
create user | 63 | <0.1 | <0.01 |
rollback | 44 | <0.1 | <0.01 |
show storage engines | 40 | <0.1 | <0.01 |
create index | 20 | <0.1 | <0.01 |
drop db | 20 | <0.1 | <0.01 |
rename table | 17 | <0.1 | <0.01 |
analyze | 10 | <0.1 | <0.01 |
repair | 8 | <0.1 | <0.01 |
drop index | 7 | <0.1 | <0.01 |
show processlist | 6 | <0.1 | <0.01 |
drop function | 4 | <0.1 | <0.01 |
show open tables | 4 | <0.1 | <0.01 |
create trigger | 2 | <0.1 | <0.01 |
create function | 2 | <0.1 | <0.01 |
empty query | 1 | <0.1 | <0.01 |
slave stop | 1 | <0.1 | <0.01 |
create db | 1 | <0.1 | <0.01 |
reset | 1 | <0.1 | <0.01 |