I do think you should see something in mysql slow log except those LOCKs. On Fri, Feb 8, 2008 at 5:26 PM, asklorz <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com >
-- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com