[rt-users] RT 3.6 performance problems

[Jesse Vincent]

On Mon, Aug 21, 2006 at 04:32:51PM -0500, Jackie Hamilton wrote:
> 
> I've just upgraded our RT install to 3.6.1, and am having some problems with it.
> 
> I can log in ok; I see the landing page; I can edit configuration, preferences, tools, etc. But the Tickets link is the link of doom.
> 
> If I click on "Tickets", I get the beginnings of a Query Builder page, but it just thrashes around in an endless load state for about 10 minutes (with apache chewing up >700 meg and 99% cpu), then eventually dies. I get a partial form - pull-downs for id, subject, queue, status and owner. It gets about halfway through the Owner list before dying.
> 
> We're using MySQL 5.0.22, and we have 156,000 users in the Users table.  I'm suspecting that's the problem.
> 

We've had a lot of problems with MySQL 5.0's query optimizer. I'd
strongly consider running 4.1 in production instead.


> I'm curious if anyone else is successfully using RT3 for a large number of users? Is there any solution here other than deleting a bunch of users?
> 
> Thanks,
> 
> -- Jackie Hamilton 
> kira at lightsphere.com
> _______________________________________________
> 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
> 

--