[rt-users] RT tuning problems

[Christoph Dittberner]

Hi,

Search this mailinglist for related posts with keyword "speed". There is 
an interesting thread with topic "Speeding up RT3".

We got exactly the same problem with RT 3.0.10, But we solved it 
refreshing the DBIx::SearchBuilder Module. The performance boost was 
amazing.

[Quote from "speeding up rt3" Jesse Vincent]
>>> What DBIx::SearchBuilder are you running?
>> 1.01
> Go up to the latest. We saw noticable performance improvements using the latest DBIx::SearchBuilder 


Richard Skelton schrieb:
> 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?
>>
>>  
>>
>