Angaben | # | ø pro Stunde | % |
---|---|---|---|
select | 51.192 k | 1.109,5 k | 86,99 |
insert | 1.269 k | 27,5 k | 2,16 |
set option | 1.185 k | 25,7 k | 2,01 |
commit | 1.035 k | 22,4 k | 1,76 |
begin | 1.035 k | 22,4 k | 1,76 |
update | 901 k | 19,5 k | 1,53 |
show fields | 477 k | 10,3 k | <0.01 |
change db | 474 k | 10,3 k | <0.01 |
delete | 311 k | 6.745,9 | <0.01 |
show tables | 240 k | 5.200,5 | <0.01 |
stmt prepare | 102 k | 2.205,9 | <0.01 |
stmt execute | 102 k | 2.205,9 | <0.01 |
stmt close | 102 k | 2.202,9 | <0.01 |
show table status | 78.076 | 1.692,1 | <0.01 |
show triggers | 77.298 | 1.675,3 | <0.01 |
create table | 57.896 | 1.254,8 | <0.01 |
show create table | 40.966 | 887,9 | <0.01 |
rollback to savepoint | 39.924 | 865,3 | <0.01 |
show status | 36.000 | 780,2 | <0.01 |
delete multi | 16.742 | 362,9 | <0.01 |
show variables | 13.038 | 282,6 | <0.01 |
show slave status | 12.777 | 276,9 | <0.01 |
replace | 8.734 | 189,3 | <0.01 |
show binlogs | 6.993 | 151,6 | <0.01 |
show slave hosts | 6.921 | 150 | <0.01 |
show engine status | 5.598 | 121,3 | <0.01 |
insert select | 4.451 | 96,5 | <0.01 |
stmt send long data | 2.850 | 61,8 | <0.01 |
show keys | 2.404 | 52,1 | <0.01 |
unlock tables | 1.437 | 31,1 | <0.01 |
show charsets | 1.165 | 25,2 | <0.01 |
do | 1.062 | 23 | <0.01 |
show warnings | 885 | 19,2 | <0.01 |
lock tables | 759 | 16,4 | <0.01 |
show function status | 686 | 14,9 | <0.01 |
show procedure status | 686 | 14,9 | <0.01 |
release savepoint | 679 | 14,7 | <0.01 |
show events | 679 | 14,7 | <0.01 |
savepoint | 679 | 14,7 | <0.01 |
show create db | 644 | 14 | <0.01 |
truncate | 559 | 12,1 | <0.01 |
drop table | 491 | 10,6 | <0.01 |
show grants | 484 | 10,5 | <0.01 |
alter table | 397 | 8,6 | <0.01 |
optimize | 102 | 2,2 | <0.01 |
show plugins | 80 | 1,7 | <0.01 |
show master status | 72 | 1,6 | <0.01 |
empty query | 34 | 0,7 | <0.01 |
checksum | 32 | 0,7 | <0.01 |
alter user | 30 | 0,7 | <0.01 |
grant | 19 | 0,4 | <0.01 |
show storage engines | 15 | 0,3 | <0.01 |
revoke | 14 | 0,3 | <0.01 |
update multi | 10 | 0,2 | <0.01 |
drop user | 10 | 0,2 | <0.01 |
revoke all | 7 | 0,2 | <0.01 |
create user | 6 | 0,1 | <0.01 |
show create func | 4 | 0,1 | <0.01 |
show collations | 4 | 0,1 | <0.01 |
show databases | 3 | 0,1 | <0.01 |
drop db | 2 | <0,1 | <0.01 |
slave stop | 1 | <0,1 | <0.01 |
reset | 1 | <0,1 | <0.01 |
create db | 1 | <0,1 | <0.01 |