[rt-users] RT tuning problems

[Todd Chapman]

I would try RT3.2.3rc1 and make sure that you have the latest
DBIx::SearchBuilder. Don't forget to restart Apache...

-Todd

On Wed, Jan 05, 2005 at 09:46:08AM +0100, 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?
> 
> -- 
>  Rafael Martinez, <r.m.guerrero at usit.uio.no>
>  Center for Information Technology Services
>  University of Oslo, Norway
> 
> The problem is that our customer complains about the time it takes to load
> a long ticket history, and this is a "show-stopper" for us. The latest
> version of DBIx::SearchBuilder is also installed.
> 
> --
> ________________________________________________________________________
> Tomas A. P. Olaj, email: tomas.olaj at usit.uio.no, web: folk.uio.no/tomaso
>  University of Oslo / USIT (Center for Information Technology Services)
>    System- and Application Management / Applications Management Group
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com