[rt-users] rt3.x perfomance degradation (~500%)

[Jesse Vincent]

On Thu, Jul 24, 2003 at 06:25:12PM +0400, Ruslan U. Zakirov wrote:
>        Hello.
> Have done snapshot of our RT DB.
> Have setup test machine with RT2 and RT3(DB same db generated with 
> ugrade tools v1.16).
> Start apache with rt2 and make ab test on index.html with cookie 
> sending. Repeat same twice. Use last result(cause of mason caching).
> Same with rt3.
> Every thing has same setup with almost default configs.
> linux 2.4.21+apache 1.3.28+mod_perl 1.28+mySQL 3.23.x+perl 5.8.0+all 
> latest needed modules from CPAN+RT 3.0.4 <=> RT 2.0.15
> !!!Diff at the end and it about 500% overall time DEGRADATION!!!

You need to move to mysql 4.0.13 or newer. This will make a
HUGE difference in performance.  I'm betting that you don't actually
even have innodb tables enabled in your mysql 3.23.  Both of those
things are killers.


> 
> Questions:
>    1) Why it is happenings? What to do with it? How to speed up RT3 to 
> RT2 level?
>    2) Tried to use Mason cache enlarge to 100MB from default and add 
> static_code flag through httpd.conf, but no significant changes. May be 
> it's wrong to do it in httpd.conf? May be in code? I didn't find how to 
> look at Mason runtime config(some pointd on it?).
>    3) Somebody did or can do mySQL upgrade(3.x -> 4.x) perfomance test?
>    4) Interesting aspect is mySQL vs Postgres?
>    4) Sometimes while first preparation tests I's starting `top` and 
> almost all the time mySQL used ~100% CPU. May be I could use some 
> aditionals mySQL options to speed it up for RT3 only.
> 

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.