[rt-users] RT 3.8.1 too slow

[Jesse Vincent]

Varad,

You haven't given us a whole lot to go on: Some things that 
folks here will need to know before anyone's going to
be able to help you:

* Exactly what version of MySQL?

* How much have you tuned mysql? 

* What does mysqltuner from mysqltuner.com say?

* Is there a reason you're running the not-really-ready MySQL 5.1 rather
  than the good-deal-more-stable MySQL 5.0 series?

* Exactly what version of Perl? Is it a Red Hat Enterprise Build? Before
 or after the massive performance fix?

* Have you looked into MySQL's slow query log?

* Have you considered setting up a second host for mail handling?

* Tell us about how you've tuned mod_perl/FastCGI

* Show us what queries are slow and the 'explain' output on those.

And, of course, if time is of the essence and you don't have the
necessary resources to tune your RT instance, Best Practical's crack
team of engineers would be happy to work to get your RT instance purring
like a kitten.

Best,

Jesse Vincent
Best Practical


On Fri 26.Dec'08 at  8:35:14 +0530, varad gupta wrote:
>    DEar All
> 
>    I have a fairly large implementation of RT running on Apache 2/ MySQL 5.1
> 
>    The problem is that it is too slow.
> 
>    On looking into the issue, I have realised that if I disable the incoming
>    mails to RT, the speed becomes acceptable.
> 
>    Once, incoming mail is piped to RT thru  rt-mailgate, RT again becomes
>    unbearably slow. I have tried all the things listed in the Performance
>    Tuning section of the RT Wiki.
> 
>    I believe at the time of writing into the database, mails take a huge
>    amount of time.
> 
>    Is there a solution to this, because otherwise I might have to uninstall
>    RT as the customer is not very happy about the performance.
> 
>    The expected load is about 50,000 mails(tickets-created or corresponded)
>    per day and about 10 helpdesk agents to handle those tickets in 3 shifts
>    of 8 hrs each. Hardware is dual core Xeon with 4 GB of RAM. Database size
>    is currently around 4 GB.
> 
>    Mostly, I feel that the problem is with the Attachments table as queries
>    onto this table take a very very long time.
> 
>    Any help would be deeply appreciated,
> 
>    Regards
> 
>    vbg

> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com

-- 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081225/30abb9a9/attachment.sig>