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

[Ruslan Zakirov]

I do think you should see something in mysql slow log except those LOCKs.

On Fri, Feb 8, 2008 at 5:26 PM, asklorz <as at dunkel.de> wrote:
>
>  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.
>
>  _______________________________________________
>  http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>  Community help: http://wiki.bestpractical.com
>  Commercial support: sales at bestpractical.com
>
>
>  Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>  Buy a copy at http://rtbook.bestpractical.com
>



-- 
Best regards, Ruslan.