[rt-users] weird Slow SelectOwner query

Alexander Boström abo at kth.se
Thu Nov 23 11:36:49 EST 2006


tor 2006-06-01 klockan 16:55 +0400 skrev Ruslan Zakirov:
> I've investigated more on this problem and found out that this problem
> of mysql as couldn't optimize well some queries when it's possible, I
> know how to hack a workaround and help RDBMs optimize it, but later...
> -EHAVENOTIME

The following seems to help MySQL optimize the query better:

alter table ACL add key ACLKTH1 using BTREE (PrincipalType, RightName);

/Alexander





More information about the rt-users mailing list