[rt-users] RT 3.0 Speed

[Simon Woodward]

Hi,

I have just completed a transfer from 2 to 3 and I am seeing something
very similar:

Single Athlon 1Ghz
512Mb RAM
RT 3.0.1
Apache 1.3.27
MySQL 4.0.12
Linux 2.2.17 
perl 5.8.0
mod_perl 1.27
HTML-Mason-1.19
All perl dependencies etc met, (see below for output).

MySQL specific configuration:

datadir=/usr/local/var/mysql
innodb_data_file_path=ibdata1:10M:autoextend:max:2000M
innodb_buffer_pool_size=128M
innodb_additional_mem_pool_size=32M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1


RT3 is just running dog slow, on the same system that runs RT2 at a
decent speed. The only difference I can say other than the difference
between RT2 and RT3 is that RT3 is using InnoDB where as RT2 was not.

I've never used InnoDB before, so am ploughing through MySQL manuals and
looking at performance tweaks, however it can take 30 seconds to a minut
+ to load the first screen, and similar for any action that uses the DB.

Any suggestions, pointers or whatever, (aside from RTFM, cos I am doing
... lots) ... I would greatly appreciate it. But I can sympathise with
Dan as I am getting lots of grief and its at times taking the box right
over and slowing everything else down that runs on it.

Cheers,

Simon.

== Dependency Output: ==

MASON dependencies:
        Params::Validate 0.02...found
        Cache::Cache ...found
        Exception::Class ...found
        HTML::Mason 1.16...found
        MLDBM ...found
        Errno ...found
        FreezeThaw ...found
        Digest::MD5 ...found
        CGI::Cookie 1.20...found
        Storable ...found
        Apache::Session 1.53...found
MAILGATE dependencies:
        HTML::TreeBuilder ...found
        HTML::FormatText ...found
        Getopt::Long ...found
        LWP::UserAgent ...found
MODPERL1 dependencies:
        CGI ...found
        Apache::Request ...found
        Apache::DBI ...found
CLI dependencies:
        Getopt::Long 2.24...found
CORE dependencies:
        Digest::MD5 ...found
        DBI 1.18...found
        Test::Inline ...found
        Class::ReturnValue 0.40...found
        DBIx::SearchBuilder 0.80...found
        Text::Template ...found
        File::Spec 0.8...found
        HTML::Entities ...found
        Net::Domain ...found
        Log::Dispatch 2.0...found
        Locale::Maketext 1.04...found
        Locale::Maketext::Lexicon 0.10...found
        Locale::Maketext::Fuzzy ...found
        MIME::Entity 5.108...found
        Mail::Mailer 1.57...found
        Net::SMTP ...found
        Text::Wrapper ...found
        Time::ParseDate ...found
        File::Temp ...found
        Term::ReadKey ...found
        Text::Autoformat ...found
        Text::Quoted ...found
DEV dependencies:
        Regexp::Common ...found
        Time::HiRes ...found
        Test::Inline ...found
        WWW::Mechanize ...found
MYSQL dependencies:
        DBD::mysql 2.1018...found