Angaben | # | ø pro Stunde | % |
---|---|---|---|
select | 4.411 M | 562,3 k | 75,68 |
insert | 390 M | 49,7 k | 6,69 |
commit | 189 M | 24 k | 3,24 |
begin | 189 M | 24 k | 3,24 |
update | 158 M | 20,1 k | 2,70 |
set option | 153 M | 19,5 k | 2,62 |
show fields | 83.848 k | 10,7 k | 1,44 |
change db | 57.975 k | 7.390,9 | <0.01 |
delete | 34.423 k | 4.388,4 | <0.01 |
show tables | 27.941 k | 3.562 | <0.01 |
stmt execute | 26.713 k | 3.405,5 | <0.01 |
stmt prepare | 26.709 k | 3.405 | <0.01 |
stmt close | 26.707 k | 3.404,8 | <0.01 |
show table status | 11.413 k | 1.455 | <0.01 |
show triggers | 11.223 k | 1.430,7 | <0.01 |
show create table | 5.983 k | 762,7 | <0.01 |
rollback to savepoint | 5.621 k | 716,6 | <0.01 |
show status | 5.335 k | 680,1 | <0.01 |
show slave status | 2.194 k | 279,7 | <0.01 |
show variables | 2.155 k | 274,7 | <0.01 |
create table | 1.810 k | 230,7 | <0.01 |
delete multi | 1.785 k | 227,5 | <0.01 |
show binlogs | 1.175 k | 149,8 | <0.01 |
show slave hosts | 1.174 k | 149,7 | <0.01 |
show engine status | 950 k | 121,1 | <0.01 |
rollback | 867 k | 110,5 | <0.01 |
stmt send long data | 797 k | 101,6 | <0.01 |
insert select | 513 k | 65,4 | <0.01 |
alter db | 476 k | 60,7 | <0.01 |
alter table | 356 k | 45,4 | <0.01 |
replace | 340 k | 43,3 | <0.01 |
unlock tables | 275 k | 35 | <0.01 |
show keys | 240 k | 30,6 | <0.01 |
drop table | 240 k | 30,5 | <0.01 |
update multi | 204 k | 26 | <0.01 |
lock tables | 186 k | 23,7 | <0.01 |
show errors | 104 k | 13,2 | <0.01 |
show procedure status | 85.994 | 11 | <0.01 |
show function status | 85.994 | 11 | <0.01 |
savepoint | 79.246 | 10,1 | <0.01 |
release savepoint | 79.239 | 10,1 | <0.01 |
show events | 78.866 | 10,1 | <0.01 |
show create db | 78.627 | 10 | <0.01 |
truncate | 63.490 | 8,1 | <0.01 |
show warnings | 27.787 | 3,5 | <0.01 |
optimize | 18.740 | 2,4 | <0.01 |
show databases | 16.175 | 2,1 | <0.01 |
show grants | 15.592 | 2 | <0.01 |
show master status | 10.019 | 1,3 | <0.01 |
alter user | 7.108 | 0,9 | <0.01 |
grant | 3.782 | 0,5 | <0.01 |
revoke all | 3.198 | 0,4 | <0.01 |
show plugins | 2.701 | 0,3 | <0.01 |
purge | 862 | 0,1 | <0.01 |
show create func | 644 | 0,1 | <0.01 |
revoke | 641 | 0,1 | <0.01 |
show storage engines | 619 | 0,1 | <0.01 |
show create trigger | 514 | 0,1 | <0.01 |
drop user | 413 | 0,1 | <0.01 |
show charsets | 406 | 0,1 | <0.01 |
create user | 299 | <0,1 | <0.01 |
show create proc | 256 | <0,1 | <0.01 |
load | 107 | <0,1 | <0.01 |
rename table | 88 | <0,1 | <0.01 |
create index | 73 | <0,1 | <0.01 |
analyze | 73 | <0,1 | <0.01 |
drop db | 60 | <0,1 | <0.01 |
kill | 58 | <0,1 | <0.01 |
check | 40 | <0,1 | <0.01 |
show collations | 40 | <0,1 | <0.01 |
show processlist | 24 | <0,1 | <0.01 |
drop index | 9 | <0,1 | <0.01 |
create db | 7 | <0,1 | <0.01 |
flush | 3 | <0,1 | <0.01 |
repair | 3 | <0,1 | <0.01 |
reset | 2 | <0,1 | <0.01 |
change master | 2 | <0,1 | <0.01 |
slave stop | 2 | <0,1 | <0.01 |
slave start | 2 | <0,1 | <0.01 |
checksum | 1 | <0,1 | <0.01 |
empty query | 1 | <0,1 | <0.01 |