[rt-users] RT tuning problems

[Ruslan U. Zakirov]

Tomas A. P. Olaj wrote:
> On the marvelous Wed, 5 Jan 2005, Todd Chapman wrote kindly to me ...
> 
> 
>>I would try RT3.2.3rc1 and make sure that you have the latest
>>DBIx::SearchBuilder. Don't forget to restart Apache...
>>
>>-Todd
> 
> 
> Thanks, all You people for helping!
> 
> We run RT3.2.1 (not sure if RT3.2.2 has better performance) and
> DBIx::SearchBuilder 1.16, and still have problems with long history
> tickets.
Here you should start Debug&Profile:
http://wiki.bestpractical.com/?Debug

> 
> As for now, we greatly appreciate all responces and help, and our
> conclusion from the latest responses is that the problem is RT itself
> (the latest stable release)?
Upcoming 3.4 series are a *lot* faster. You can copy you current setup 
and upgrade it to 3.4.0rc1 and see how it works for you.

> 
> Is it faster to run FastCGI or modperl? We are currently testing to find
> the optimal Apache dist to run.
Autrijus said latest mod_perl2 and FastCGI works at the same speed, but 
MP2 has lower memory usage.

> 
> cheers,
> Tomas
> 
> 
>>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
> 
>