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

Which mysql version? Which my.cnf? Did you apply the “extra” indexes?

A.-----Original Message-----
From: rt-users-admin@lists.fsck.com [mailto:rt-users-admin@lists.fsck.com]
On Behalf Of Daryl G. Jurbala
Sent: Tuesday, August 19, 2003 8:33 PM
To: rt-users@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@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

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.

ThanksOn 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@lists.fsck.com [mailto:rt-users-admin@lists.fsck.com]
On Behalf Of Daryl G. Jurbala
Sent: Tuesday, August 19, 2003 8:33 PM
To: rt-users@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:
Index of /pgp


rt-users mailing list
rt-users@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@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

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

A.From: Asif Iqbal [mailto:iqbala@qwestip.net]
Sent: Thursday, August 21, 2003 3:47 PM
To: Aleš Sušnik
Cc: rt-users@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

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@qwestip.net]
Sent: Thursday, August 21, 2003 3:47 PM
To: Ale¹ Su¹nik
Cc: rt-users@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

Which mysql version? Which my.cnf? Did you apply the “extra” indexes?

A.

-----Original Message-----
From: rt-users-admin@lists.fsck.com [mailto:rt-users-admin@lists.fsck.com]
On Behalf Of Daryl G. Jurbala
Sent: Tuesday, August 19, 2003 8:33 PM
To: rt-users@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:
Index of /pgp


rt-users mailing list
rt-users@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@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