[rt-users] Performance problems with 3.8.1

[Curtis Bruneau]

For FastCGI, I changed my configuration to allow multiple processes so 
other requests aren't getting queued up when big queries are hitting the 
server. Without this setting the site was pretty slow to respond but 
once the request got in it was fast. I've also changed the default idle 
timeout to something similar to mod_perl2, the default was triggering on 
normal stuff, some un-indexed fields in search were causing really slow 
count()s..

FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 300 -processes 4

Also the recommended shared buffers would be tailored to your instance, 
in our case we have nearly 1GB in indexes alone so ours is set fairly 
high. Generally you want it high enough so it doesn't have to swap out 
indexes all the time.

Curtis

Sahlberg Mauri wrote:
>
> Hi,
>
> Just upgraded from 3.6 to 3.8.1 (via 3.8) and at the same time moved 
> the database to it’s own server. We also removed all closed tickets 
> from the database. The move and upgrade was done as our old 
> installation got too slow. Unfortunately the new installation is also 
> very slow despite the ticket removal and dedicated database server. 
> Especially search building view and ticket view take time to open.
>
> We have:
>
> - Checked that weI have newest DBIx:search builder installed
>
> - Checked that both our database server (CentOS 5.2 final) and web 
> server (CentOS 5.2 final) fulfill the minimum shared memory settings 
> suggested at the wiki
>
> - Have FastCGI installed on Apache 2.2.3, standard CentOS 5.2 final 
> binary (standard CentOS 5.2 perl 5.8.8 with make fixdeps installed 
> modules)
>
> - Our Postgresql 8.1.11 (Centos 5.2 standard binary) has more 
> shared_buffers and temp_buffers than suggested at the wiki
>
> - Installed pg_top and tried to isolate the query that hogs the machine
>
> Any suggestions what we could yet do to speed things up?
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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