[rt-users] RT 3.0.4/MySQL Slow

[Aleš Sušnik]

create index group1 on CachedGroupMembers (GroupId);
create index member1 on CachedGroupMembers (MemberId);

A.

-----Original Message-----
From: Asif Iqbal [mailto:iqbala at qwestip.net] 
Sent: Thursday, August 21, 2003 3:47 PM
To: Aleš Sušnik
Cc: rt-users at lists.fsck.com
Subject: RE: [rt-users] RT 3.0.4/MySQL Slow


Ale

I would be interested to look at the extra indexes as well. Are they posted
somewhere ? I am also considering to switch to my-huge.cnf, one more time --
it crashed once in the
past, as you suggested in an earlier email.

Thanks

On Wed, 20 Aug 2003, [iso-8859-2] Aleš Sušnik wrote:

> Which mysql version? Which my.cnf? Did you apply the "extra" indexes?
>
> A.
>
> -----Original Message-----
> From: rt-users-admin at lists.fsck.com [mailto:rt-users-admin at lists.fsck.com]
> On Behalf Of Daryl G. Jurbala
> Sent: Tuesday, August 19, 2003 8:33 PM
> To: rt-users at lists.fsck.com
> Subject: [rt-users] RT 3.0.4/MySQL Slow
>
>
> I know this has been mentioned before, plenty of times, but I'm looking
> for a good way to figure out what my issues are and how to resolve them,
> or if this is as good as it gets for now with 3.x.
>
> I've got a very small database (135 tickets or so), and it takes over 20
> seconds to perform almost any operation.  The CPU is not pegged, there
> isn't a lot of disk access, and the VM does nothing else other than run
> RT (it's a Debian VM under GSX server).  Similar VMs on the same host
> run just fine, so it's not a VM issue.
>
> Daryl G. Jurbala
> Introspect.net Consulting
> Tel: +1 215 825 8401
> Fax: +1 508 526 8500
> http://www.introspect.net
>
> PGP Key and Adobe Digital Signature:
> http://www.introspect.net/pgp
> _______________________________________________
> 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
>
>
> _______________________________________________
> 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
>

-- 
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.0.0.1