[rt-users] Every click on a ticket takes 10 seconds

[asklorz]

When clicking on a ticket, it takes 10 sec for the page to build up. The left
column of the site (the basics, people, more about xxx xxx) builds up in
under 1 sec, but the right column and the bottom (reminders, dates, links,
history) takes every time 9-10 seconds to show up.

Apache log with request time:
xxx.xxx.xxx.xxx - - [31/Jan/2008:04:01:27 -0500] "GET
/Ticket/Display.html?id=5335 HTTP/1.1" 200 282977 "http://xxxxxx.xx/"
"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127
Firefox/2.0.0.11" 9597932

The box has enough free ram, and is 99% idle. In the MySQL I can see many
locks like this:

# Query_time: 9  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
SELECT GET_LOCK('Apache-Session-bbe05f8fb2d2792dfb16441a94e7f351', 3600);

This locks seems not the be the source of the problem but the consequence.
I switched temporarily to file system based sessions, but the behavior was
the same. Every click on a ticket took near 10 seconds.

The installation holds a few tickets and there are 3 people using it.

While the site builds up I can see that libperl.so takes 80% of the CPU
time.

Versions:

OS: CentOS 5 
Apache/2.2.3
MySQL 5.0.22
Perl 5.8.8
RT: 3.6.6 (problem existed in 3.6.5 too)
SELinux: disabled

Could anyone please help me in debugging this problem?

Best regards

Adalbert
-- 
View this message in context: http://www.nabble.com/Every-click-on-a-ticket-takes-10-seconds-tp15200974p15200974.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.