...@lists.bestpractical.com] On Behalf Of Justin
Hayes
Sent: 01 July 2010 11:39
To: Kenneth Crocker
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments, so I
assume that's not an issue
] On Behalf Of Justin
Hayes
Sent: 01 July 2010 11:39
To: Kenneth Crocker
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments, so I
assume that's not an issue?
Cheers,
Justin
@lists.bestpractical.com
Subject: Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments, so I
assume that's not an issue?
Cheers,
Justin
-
Justin Hayes
OpenBet Support Manager
justin.ha...@openbet.com
-users@lists.bestpractical.com
Subject: Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments, so I
assume that's not an issue?
Cheers,
Justin
-
Justin Hayes
OpenBet Support Manager
@lists.bestpractical.com
Subject: Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments, so I
assume that's not an issue?
Cheers,
Justin
-
Justin Hayes
OpenBet Support Manager
...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Justin
Hayes
Sent: 01 July 2010 11:39
To: Kenneth Crocker
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments
-users-
boun...@lists.bestpractical.com] On Behalf Of Justin Hayes
Sent: 09 September 2010 15:19
To: Kenneth Marshall
Cc: rt-users@lists.bestpractical.com Users
Subject: Re: [rt-users] Slow Ticket History 3.8.8
I actually liked the incremental page load, as I could read the start of
the ticket
Thanks Jeffrey. We're already using UseSQLForACLChecks and don't use web
external auth. Tried the combination you've given though and unfortunately no
difference :(
-
Justin Hayes
OpenBet Support Manager
justin.ha...@openbet.com
On 7 Sep 2010, at
...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Justin Hayes
Sent: 01 July 2010 11:39
To: Kenneth Crocker
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file
@lists.bestpractical.com
Subject: Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments, so I
assume that's not an issue?
Cheers,
Justin
-
Justin Hayes
OpenBet Support Manager
justin.ha
than 5 seconds.
Regards;
Roy
*From:* rt-users-boun...@lists.bestpractical.com [mailto:
rt-users-boun...@lists.bestpractical.com] *On Behalf Of *Justin Hayes
*Sent:* 01 July 2010 11:39
*To:* Kenneth Crocker
*Cc:* rt-users@lists.bestpractical.com
*Subject:* Re: [rt-users] Slow Ticket
To: Kenneth Crocker
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments, so I
assume that's not an issue?
Cheers,
Justin
-
Justin
July 2010 11:39
*To:* Kenneth Crocker
*Cc:* rt-users@lists.bestpractical.com
*Subject:* Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments, so I
assume that's not an issue?
Cheers,
Justin
Hayes
Sent: 01 July 2010 11:39
To: Kenneth Crocker
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments, so I
assume that's not an issue?
Cheers,
Justin
:39
*To:* Kenneth Crocker
*Cc:* rt-users@lists.bestpractical.com
*Subject:* Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments, so I
assume that's not an issue?
Cheers,
Justin
-
Justin
@lists.bestpractical.com
*Subject:* Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments, so I
assume that's not an issue?
Cheers,
Justin
-
Justin Hayes
OpenBet Support Manager
justin.ha
seconds.
Regards;
Roy
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Justin Hayes
Sent: 01 July 2010 11:39
To: Kenneth Crocker
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Slow Ticket History 3.8.8
Hi Justin, I've recently been using siege to bash on RT, and have been
testing the following two settings in our RT_SiteConfig.pm
Set($UseSQLForACLChecks, 1);
Set($WebExternalAuthContinuous, 0);
The combined effect has been a serious reduction in rendering speed in
general, and particularly
We do Kenneth, but most tickets don't have many file attachments, so I assume
that's not an issue?
Cheers,
Justin
-
Justin Hayes
OpenBet Support Manager
justin.ha...@openbet.com
On 29 Jun 2010, at 17:54, Kenneth Crocker wrote:
Justin,
I
Thanks a lot for this response Kim.
r.e. the joins without indexes. How can we work out which indexes we need? I'd
have thought this would cause slow queries but we're not seeing any...
We're trying to tune on our test server before making any changes to live,
however the hardware etc is
to less than 5 seconds.
Regards;
Roy
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Justin Hayes
Sent: 01 July 2010 11:39
To: Kenneth Crocker
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Slow Ticket
From: Justin Hayes [mailto:justin.ha...@openbet.com]
Sent: 01 July 2010 12:08
To: Raed El-Hames
Subject: Re: [rt-users] Slow Ticket History 3.8.8
Hi Raed,
How big is your DB? We've got about 10gb in Attachments. If we put a really
long ticket in an empty DB performance is excellent
On Thu, Jul 01, 2010 at 02:30:56PM +0100, Justin Hayes wrote:
Hi Roy,
We've logged the SQL statements on the test server - virtually every query is
.000s of a second. Yet the ticket we're using on there still takes 12s to
render.
So the queries seem ok. However I know that having a huge
@lists.bestpractical.com
*Subject:* Re: [rt-users] Slow Ticket History 3.8.8
We do Kenneth, but most tickets don't have many file attachments, so I
assume that's not an issue?
Cheers,
Justin
-
Justin Hayes
OpenBet Support Manager
justin.ha...@openbet.com
to determine which bit of code is taking the longest time etc etc.
Feel free to mail me again if you need further help.
Regards;
Roy
*From:* Justin Hayes [mailto:justin.ha...@openbet.com]
*Sent:* 01 July 2010 12:08
*To:* Raed El-Hames
*Subject:* Re: [rt-users] Slow Ticket History 3.8.8
Hi Raed,
How
Hi Justin,
Our RT instance is much smaller than yours, but we had very similar
problems.
Optimizing MySQL using the output from the tuner script made nearly all
the speed issues go away.
The one remaining issue we had with slow queries was resolved after the
upgrade to 3.8.8
Your key
Hi everyone,
I've raised this before, but we've had another look at it and still can't see
how to improve things.
We put a lot of comments/replies in our tickets. Often there can be 50-100
entries in a ticket, mostly plain text. Loading such a ticket can take
10-20secs.
We don't have any
Quite outside of the speed of RT, what database are you using as a
back-end? How long has it been since you did some care and feeding of
your database? How big are your tables? If you are using mysql or
postgres have you used their tools to examine your database,
especially the indexes and
Hi Charles,
But as far as we can tell from our profiling the time is spent in the perl
rendering the ticket, not in the query used to retrieve the ticket and
attachments in the first place (which happens once at the start I believe). The
loop that renders the ticket history and each attachment
Hi,
If you are using mysqld have a look at mysqltuner.pl perl script
(google)
This has fixed quickly many performance issues on both RT and other
web-based software we use. I run this every few weeks and apply
suggested
changes and then simply restart mysqld when things are quite.
Regards,
Justin, thank you for the kindness of your reply. I didn't intend to
send you chasing rabbits, so to speak. Just offering something to add
to the checklist of items to be crossed off before digging too deeply
into the perl code. If you are convinced that mysql is performing at
its best
Thanks Jason - I'll give that a go as well. We have got a large DB (~10gb) so
keeping it tuned is definitely important.
However as stated the time seems to be lost in code, after I'd have thought it
had run the query for the ticket (though I may be wrong in that assumption).
Cheers,
Justin
Hehe thanks Charles.
I think you might have a point anyway. Running that script recommended by Jason
has thrown up a few things that need tweaking with mysql.
Not sure what some of them mean yet, and not sure if it'll help, but we'll see.
I appreciate you helping believe me!
Justin
...@lists.bestpractical.com on behalf of Justin Hayes
Sent: Tue 6/29/2010 9:28 AM
To: Jason Doran
Cc: rt Users
Subject: Re: [rt-users] Slow Ticket History 3.8.8
Thanks Jason - I'll give that a go as well. We have got a large DB (~10gb) so
keeping it tuned is definitely important.
However as stated
Seem to be quite a few things to look at Jason. Need to figure out what they
all mean first.
Justin
General Statistics --
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version
table... dropped the index, and performance was back to normal (pre
3.8.8)
Nicola
-Original Message-
From: rt-users-boun...@lists.bestpractical.com on behalf of Justin Hayes
Sent: Tue 6/29/2010 9:28 AM
To: Jason Doran
Cc: rt Users
Subject: Re: [rt-users] Slow Ticket History 3.8.8
As a test we've just created a long ticket in an empty RT DB and it's very
fast. So does look to be DB related - contrary to our earlier investigations.
I guess it must still access the DB resultset during the ticket rendering
(which isn't how we thought it would work).
Time to tune the hell
Justin,
I didn't see this mentioned and may have missed it, but are you displaying
attachements inline? That might cut back on the I/O for History. Just a
thought.
Kenn
LBNL
On Tue, Jun 29, 2010 at 8:04 AM, Justin Hayes justin.ha...@openbet.comwrote:
As a test we've just created a long ticket
38 matches
Mail list logo
