[rt-users] RT 3.0.4/MySQL Slow

[Asif Iqbal]

On Thu, 21 Aug 2003, [iso-8859-2] Ale¹ Su¹nik wrote:

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

I did that, did not help

It is taking over 15 secs to display a ticket now, just by using curl. Takes lot
longer through the web

>
> 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