[rt-users] RT tuning problems

[Richard Skelton]

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