[rt-users] RT 3.2.2 very slow

[Jaime Kikpole]

     I have RT 3.2.2 with RT/FM installed on Apache 1.3.31 with mod_perl 1.29
and MySQL 4.1.7 on FreeBSD 4.10-Stable.  I've had problems ever since
moving (last October) to RT3 from very happy life with 2.0.15.

     I think that I finally figured out part of it, which was an
/etc/newsyslog.conf config error.  I made a correction earlier today
based on http://www.freebsddiary.org/rotatelogs.php.

     Unfortunately, Apache's httpd processes still grow in memory usage to
very large sizes (400MB+ over two weeks) and sometimes take a very long
time (20+ minutes) to display long pages and unusual-but-tolerable
periods on short pages.  For example, my ticket 3267 will *never* fully
load.  Rendering will pause on screen before the third comment (usually
before any of the History section) and then never finishes even when the
httpd in question uses 99%+ of the CPU time.  I usually end up restarting
Apache after a few hours so that the box doesn't slow down.

     I've used the RT log files, the MySQL log files, Apache log files,
upgraded MySQL, upgraded Perl, upgraded Apache, reinstalled mod_perl,
upgraded to the latest DBIx::SearchBuilder from CPAN (from 1.15 to 1.16)
and have gotten no closer to figuring this out.  Upgrading the RAM to
1.5GB seems to have helped a little bit, but the main problem (not
displaying long tickets like 3267, taking too long with all tickets,
etc.) is still not solved.

     Can anyone offer any tips, pointers, docs, anecdotes, or any help?  I'm
getting desperate.  I don't want to replace RT, but I'm running out of
options.

                                                       Thanks in advance,
                                                       Jaime