Finally upgraded to 4.0.1. Works. But there are some issues:
Tried to test-run rt-clean-sessions and got:
=# /opt/rt4/sbin/rt-clean-sessions --older 7D
Can’t locate object method “_CleariOldDir” via package “RT::Interface::Web::Session” at /opt/rt4/sbin/…/lib/RT/Interface/Web/Session.pm line 173.
I’m using Apache::Session::File:
=# grep -i session /opt/rt4/etc/RTConfig
/opt/rt4/etc/RT_Config.pm:=item C<$WebSessionClass>
/opt/rt4/etc/RT_Config.pm:C<$WebSessionClass> is the class you wish to use for managing
/opt/rt4/etc/RT_Config.pm:Sessions. It defaults to use your SQL database, but if you are using
/opt/rt4/etc/RT_Config.pm:this line to F<RT_SiteConfig.pm> to prevent session corruption.
/opt/rt4/etc/RT_Config.pm:# Set($WebSessionClass, “Apache::Session::File”);
/opt/rt4/etc/RT_Config.pm:By default, RT’s user sessions persist until a user closes his or her
/opt/rt4/etc/RT_Config.pm:browser. With the C<$AutoLogoff> option you can setup session lifetime
/opt/rt4/etc/RT_Config.pm:By default, RT’s session cookie isn’t marked as “secure” Some web
/opt/rt4/etc/RT_SiteConfig.pm:Set( $WebSessionClass, ‘Apache::Session::File’ );
Also - Based on nginx logs with times, I see that 4.0.1 is much slower than 3.8.9
rendering home page took usually 0.7s, now it’s > 3s:
some_ip - - [27/Jun/2011:13:18:48 +0200] “GET / HTTP/1.1” 200 1778 “-” “Mozilla/5.0 (X11; Linux i686 on x86_64; rv:6.0a2) Gecko/20110620 Firefox/6.0a2” 3.451s
some_ip - - [27/Jun/2011:13:29:19 +0200] “GET / HTTP/1.1” 200 4032 “-” “Mozilla/5.0 (X11; Linux i686 on x86_64; rv:6.0a2) Gecko/20110620 Firefox/6.0a2” 2.900s
some_ip - - [27/Jun/2011:13:29:45 +0200] “GET / HTTP/1.1” 200 4030 “Login” “Mozilla/5.0 (X11; Linux i686 on x86_64; rv:6.0a2) Gecko/20110620 Firefox/6.0a2” 3.549s
some_ip - - [27/Jun/2011:13:33:10 +0200] “GET / HTTP/1.1” 200 4088 “Login” “Mozilla/5.0 (X11; Linux i686 on x86_64; rv:6.0a2) Gecko/20110620 Firefox/6.0a2” 6.539s
some_ip - - [27/Jun/2011:13:34:30 +0200] “GET / HTTP/1.1” 200 4032 “http://rt.depesz.com/” “Mozilla/5.0 (X11; Linux i686 on x86_64; rv:6.0a2) Gecko/20110620 Firefox/6.0a2” 0.275s
some_ip - - [27/Jun/2011:13:35:41 +0200] “GET / HTTP/1.1” 200 4031 “Login” “Mozilla/5.0 (X11; Linux i686 on x86_64; rv:6.0a2) Gecko/20110620 Firefox/6.0a2” 3.259s
some_ip - - [27/Jun/2011:13:40:10 +0200] “GET / HTTP/1.1” 200 4030 “-” “Mozilla/5.0 (X11; Linux i686 on x86_64; rv:6.0a2) Gecko/20110620 Firefox/6.0a2” 3.500s
Load on the server is ~ 0.7.
I checked DB logs, and the only thing I noticed was that I had calls to this query:
SELECT * FROM Groups WHERE LOWER(Domain) = LOWER($1) AND LOWER(Type) = LOWER($2)
groups table on my system has ~ 70k rows, and runtime of the query is ~70ms.
So I added index on lower(domain), lower(type) and got the time to < 0.1ms
index definition, in case you’d want to add it to standard rt:
create index groups_3 on groups ( LOWER(Domain), LOWER(Type) );
But it’s only ~ 70ms out of 3.5s.
Any hints on what should I look at?
Best regards,
depesz
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/