RT 3.8.1 merged tickets slow

im using RT 3.8.1, and have googled this issue extensively to no avail.

specs:

RT 3.8.1 migrated from 3.4.5
mysql 5 upgraded from mysql4 with both the RT updates as well as the UPDATE.mysql schema updates applied
apache 2.x

loading a merged ticket takes on the order of 1-2 minutes in some cases. often times fetching a merged ticket results in an apache timeout while waiting on the script.

any suggestions?

lars,
good idea. MySQL query logs show im pulling alot of info from various different tickets (of course, lusers love to merge.) curious if caching might help the situation, as precaching and output buffer adjustments to fcgid are now causing page render’s to be lightning fast.

anyone----- Original Message -----
From: Lars Kellogg-Stedman lars@oddbit.com
Date: Thursday, November 6, 2008 16:05
Subject: Re: [rt-users] RT 3.8.1 merged tickets slow
To: JOHN ROMAN cicero@insightbb.com

any suggestions?

How many tickets are in your database?

Watch your MySQL query log to see what queries this request is
generating. See if running the same queries by hand (via
mysqlclient)takes just as long. This should at least help
differentiate database
slowness from something else. It’s not a solution, but it
may suggest
where to focus your efforts.


Lars Kellogg-Stedman lars@oddbit.com

Hi John,

im using RT 3.8.1, and have googled this issue extensively to no avail.

RT 3.8.1 migrated from 3.4.5
mysql 5 upgraded from mysql4 with both the RT updates
as well as the UPDATE.mysql schema updates applied apache 2.x

loading a merged ticket takes on the order of 1-2 minutes in some cases.
often times fetching a merged ticket results in an apache timeout while
waiting on the script.

Maybe it’s this: RT tries to write hundreds of messages to syslog when opening merged tickets …

Try to decrease that using
Set($LogToSyslog , ‘info’);
in RT_SiteConfig.pm

→ See http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=498692

Regards,
Tom

Schwarz Computer Systeme GmbH
Altenhofweg 2a
92318 Neumarkt

Geschaeftsfuehrer: Manfred Schwarz
Sitz der Gesellschaft: Neumarkt i.d.Opf.
Registergericht: AG Nuernberg, HRB 11908

Diese eMail enthaelt moeglicherweise vertrauliche und/oder rechtlich geschuetzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese eMail irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese eMail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This email may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email in error) please notify the sender immediately and destroy this email. Any unauthorized copying, disclosure or distribution of the material in this email is strictly forbidden.

smime.p7s (27 KB)

congratulations Thomas, this was the problem!
RT is humming along nicely now. ill add this under performance tips in the wiki :slight_smile:

John Roman
Lexmark Intl.----- Original Message -----
From: “Knaupp, Thomas” Thomas.Knaupp@schwarz.de
Date: Friday, November 7, 2008 7:36
Subject: Re: [rt-users] RT 3.8.1 merged tickets slow
To: ‘JOHN ROMAN’ cicero@insightbb.com, “rt-users@lists.bestpractical.comrt-users@lists.bestpractical.com

Hi John,

im using RT 3.8.1, and have googled this issue extensively to
no avail.

RT 3.8.1 migrated from 3.4.5
mysql 5 upgraded from mysql4 with both the RT updates
as well as the UPDATE.mysql schema updates applied apache 2.x

loading a merged ticket takes on the order of 1-2 minutes in
some cases.
often times fetching a merged ticket results in an apache
timeout while
waiting on the script.

Maybe it’s this: RT tries to write hundreds of messages to
syslog when opening merged tickets …

Try to decrease that using
Set($LogToSyslog , ‘info’);
in RT_SiteConfig.pm

→ See http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=498692

Regards,
Tom


Schwarz Computer Systeme GmbH
Altenhofweg 2a
92318 Neumarkt
http://www.schwarz.de


Geschaeftsfuehrer: Manfred Schwarz
Sitz der Gesellschaft: Neumarkt i.d.Opf.
Registergericht: AG Nuernberg, HRB 11908


Diese eMail enthaelt moeglicherweise vertrauliche und/oder
rechtlich geschuetzte Informationen. Wenn Sie nicht der richtige
Adressat sind oder diese eMail irrtuemlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie
diese eMail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail ist nicht gestattet.

This email may contain confidential and/or privileged
information. If you are not the intended recipient (or have
received this email in error) please notify the sender
immediately and destroy this email. Any unauthorized copying,
disclosure or distribution of the material in this email is
strictly forbidden.