[rt-users] rt-2-1-85: mysql performance ?

[Jesse Vincent]

Carlos,
	What queries was it blocking on? What mysql are you running?
	Does it have support for innodb tables? That sounds like an awful lot
	of indices that you might need.  Did you use mysql's 'EXPLAIN'
	to see that your indices were all being used more efficiently?

	Thanks,
	jesse

On Thu, Mar 13, 2003 at 07:39:40PM +0000, Carlos Canau wrote:
> 
> Hi,
> 
> In my setup (*) I was waiting about 10 sec. to change from a ticket to
> the next  on the  tickets menu. After  turning on  log-slow-queries in
> mysqld I've tried the following indexes  which drop the wait time to 5
> sec. (which is still ... a lot ??). Can it be further optimized ?
> 
> 
> alter table Tickets add INDEX TypeINDEX(Type);
> alter table Tickets add INDEX StatusINDEX(Status);
> alter table Groups add INDEX DomainINDEX(Domain);
> alter table Groups add INDEX InstanceINDEX(Instance);
> alter table Groups add INDEX TypeINDEX(Type);
> alter table Principals add INDEX PrincipalsINDEX(PrincipalType);
> alter table CachedGroupMembers add INDEX GroupIdINDEX(GroupId);
> alter table CachedGroupMembers add INDEX MemberIdINDEX(MemberId);
> 
> regards,
> </canau
> 
> 
> (*)
> - rt-2-1-85
> - 9000 tickets imported from rt2
> - 2x450MHz Pentium II Compaq 3000 server
> - RH 7.3 + last patches
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.