Statements | # | ø per hour | % |
---|---|---|---|
select | 293 M | 708.2 k | 84.74 |
set option | 9,220 k | 22.3 k | 2.67 |
insert | 8,800 k | 21.3 k | 2.55 |
update | 7,900 k | 19.1 k | 2.29 |
show fields | 4,292 k | 10.4 k | 1.24 |
change db | 3,852 k | 9,314.5 | 1.11 |
commit | 3,063 k | 7,406.8 | 0.89 |
begin | 3,055 k | 7,387.6 | 0.88 |
stmt prepare | 2,416 k | 5,840.9 | 0.70 |
stmt close | 2,416 k | 5,840.8 | 0.70 |
stmt execute | 2,416 k | 5,840.8 | 0.70 |
delete | 1,850 k | 4,474.2 | 0.54 |
show tables | 1,487 k | 3,594.7 | 0.43 |
show table status | 273 k | 659.6 | 0.08 |
show status | 263 k | 636.4 | 0.08 |
show triggers | 263 k | 635.5 | 0.08 |
show create table | 154 k | 373.5 | 0.04 |
rollback to savepoint | 131 k | 317 | 0.04 |
delete multi | 124 k | 300.6 | 0.04 |
show variables | 115 k | 278.8 | 0.03 |
show slave status | 110 k | 267.1 | 0.03 |
rollback | 62,540 | 151.2 | 0.02 |
show slave hosts | 62,071 | 150.1 | 0.02 |
show binlogs | 61,989 | 149.9 | 0.02 |
stmt send long data | 54,580 | 132 | 0.02 |
show engine status | 50,114 | 121.2 | 0.01 |
insert select | 47,320 | 114.4 | 0.01 |
alter table | 37,343 | 90.3 | 0.01 |
show keys | 32,119 | 77.7 | 0.01 |
create table | 31,284 | 75.6 | 0.01 |
alter db | 24,913 | 60.2 | 0.01 |
replace | 23,040 | 55.7 | 0.01 |
unlock tables | 8,913 | 21.6 | <0.01 |
drop table | 6,748 | 16.3 | <0.01 |
show errors | 6,713 | 16.2 | <0.01 |
lock tables | 6,550 | 15.8 | <0.01 |
truncate | 3,601 | 8.7 | <0.01 |
update multi | 2,390 | 5.8 | <0.01 |
show procedure status | 2,295 | 5.5 | <0.01 |
show function status | 2,295 | 5.5 | <0.01 |
show warnings | 1,900 | 4.6 | <0.01 |
release savepoint | 1,818 | 4.4 | <0.01 |
savepoint | 1,818 | 4.4 | <0.01 |
show events | 1,788 | 4.3 | <0.01 |
show create db | 1,788 | 4.3 | <0.01 |
optimize | 1,130 | 2.7 | <0.01 |
show master status | 694 | 1.7 | <0.01 |
show grants | 612 | 1.5 | <0.01 |
alter user | 136 | 0.3 | <0.01 |
show plugins | 84 | 0.2 | <0.01 |
show databases | 78 | 0.2 | <0.01 |
grant | 75 | 0.2 | <0.01 |
show charsets | 71 | 0.2 | <0.01 |
revoke all | 59 | 0.1 | <0.01 |
show storage engines | 47 | 0.1 | <0.01 |
purge | 19 | <0.1 | <0.01 |
revoke | 16 | <0.1 | <0.01 |
show create func | 16 | <0.1 | <0.01 |
show create trigger | 10 | <0.1 | <0.01 |
drop user | 9 | <0.1 | <0.01 |
create user | 9 | <0.1 | <0.01 |
analyze | 6 | <0.1 | <0.01 |
show create proc | 6 | <0.1 | <0.01 |
rename table | 3 | <0.1 | <0.01 |
drop db | 2 | <0.1 | <0.01 |
reset | 1 | <0.1 | <0.01 |
slave stop | 1 | <0.1 | <0.01 |
show processlist | 1 | <0.1 | <0.01 |