[rt-users] RT tuning problems

[Jason A. Diegmueller]

Have you guys tried RT 3.2.3rc1 & DBIx::SearchBuilder 1.15?  I reported 
greatly improved results (to the tune of something like 300%) on our "problem 
tickets".

RT 3.4.0 showed another 20% or so improvement on top of the above numbers.

We're on Apache 1.3.33/mod_perl 1.29 as well.

-jd

On Wed, 5 Jan 2005, Richard Skelton wrote:

> Hi Thomas,
> I see the exact same problem with our 3.0.10 installations.
> I have experimented with rt-3.2.1 but it did not improve things:-(
> Our systems are:-
> Solaris 9 KJP 112233-12
> Ultra 60 2X450MHz
> 2GB Memory
> mysql 4016
> Perl 5.8.3
> Solaris bundled Apache/1.3.29
> mod_perl-1.29
>
> Tomas A. P. Olaj wrote:
>
>> This is written by our web-admin and Postgres DBA, Rafael Martinez, which
>> is not a member of this list, and forwarded to me:
>> 
>> -->
>> 
>> We are having performance problems in our RT (3.2.1) installation.
>> 
>> Description:
>> 
>> - If we try to display a ticket with a long history, it takes many
>> seconds before the webside is generated. (Ticket/Display.html?id=<ID>).
>> In some browsers (f.ex.IExplorer) the webside is not show until the
>> browser gets all the data.
>> 
>> - The server is not busy and has plenty of idle resources.
>> 
>> - We do not have problems with the database. It is not busy at all. Not
>> IO problems either.
>> 
>> - apache uses 100% of cpu when Ticket/Display.html?id=<ID> is executed.
>> If we run strace, can we see a lot of "time(NULL)=xxxxxxxx" system
>> calls, in our case, around 86000. 177 sql queries are send to the
>> database and it takes 20 seconds between the first and the last sql
>> query are send to the database.
>> 
>> - It looks like apache is in some idle/loop stage (time(NULL)=xxxxxxxx)
>> between sending and receiving data to/from the database.
>> 
>> Our system:
>> - Red Hat Enterprise Linux WS release 3 (Taroon Update 4).
>> - kernel 2.4.21-20.ELsmp
>> - 4GB Ram
>> - 2 x Intel(R) Xeon(TM) CPU 2.40GHz.
>> - 2 x scsi 36GB 15K (raid 1)
>> 
>> - We are running the webserver and the database in the same server.
>> - Database: PostgreSQL 7.3.5
>> - Webserver: apache RH version: httpd-2.0.46-44.ent with
>> mod_perl_1.99_12
>> 
>> Anyone with the same problem?
>> 
>> 
>
> -- 
>
>
>
> Cheers
>
> Richard Skelton
> Richard.Skelton at infineon.com
> Infineon Technologies UK Ltd
> Infineon House
> Great Western Court
> Hunts Ground Road
> Stoke Gifford
> Bristol
> BS32 8HP
> Tel +44(0)117 9528808
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT wiki at http://wiki.bestpractical.com
>