[rt-users] Serious performance problems

Michael Markstaller mm at elabnet.de
Wed Apr 19 05:14:05 EDT 2006 

We're running 3.4.1 on Debain Sarge with Apache1,modperl & Mysql (all packages on this system are from stable) and response times are "realtime" - 15 user approx 5000 tickets
We had RT 3.0.12 before on the same box, also no problems.
I'll post my config below, maybe it helps you to see a problem source (your versions look like being partially from sid)
 

> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com 
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf 
> Of Jörg Ungermann
> Sent: Wednesday, April 19, 2006 9:13 AM
> To: rt-users at lists.bestpractical.com
> Subject: [rt-users] Serious performance problems
> 
> Dear Sirs,
> 
> we do run RT 3.4.2 on Debian Sarge and Postgres 8
3.4.2 ? The latest package from sarge is 3.4.1, you should give it a try, it works like a charme away from apt-get install.. At least if your problems don't work out, I'd try to pull everything to stable..

Michael

--- config --
Perl v5.8.4 under linux 
  Apache v1.27;
  Apache::Connection v1.00;
  Apache::Constants v1.09;
  Apache::DBI v0.94;
  Apache::Request v1.1;
  Apache::Server v1.01;
  Apache::Session v1.6;
  Apache::Session::Generate::MD5 v2.1;
  Apache::Session::Lock::MySQL v1.00;
  Apache::Session::MySQL v1.01;
  Apache::Session::Serialize::Storable v1.00;
  Apache::Session::Store::DBI v1.02;
  Apache::Session::Store::MySQL v1.04;
  Apache::Status v2.03;
  Apache::Symbol v1.31;
  Apache::Table v0.01;
  AutoLoader v5.60;
  B v1.02;
  base v2.05;
  Benchmark v1.06;
  bytes v1.01;
  Cache::Simple::TimedExpiry v0.21;
  Carp v1.02;
  CGI v3.04;
  CGI::Cookie v1.24;
  CGI::Util v1.4;
  Class::Container v0.11;
  Class::Data::Inheritable v0.02;
  Class::ReturnValue v0.52;
  constant v1.04;
  Cwd v2.17;
  Data::Dumper v2.121;
  Date::Format v2.22;
  Date::Parse v2.27;
  DBD::mysql v2.9006;
  DBI v1.46;
  DBIx::SearchBuilder v1.26;
  Devel::StackTrace v1.11;
  Devel::StackTraceFrame v0.6;
  Devel::Symdump v2.03;
  Digest::base v1.00;
  Digest::MD5 v2.33;
  DynaLoader v1.04;
  Encode v1.99_01;
  Encode::Alias v1.38;
  Encode::Config v1.07;
  Encode::Encoding v1.33;
  Errno v1.09;
  Exception::Class v1.20;
  Exception::Class::Base v1.2;
  Exporter v5.58;
  Exporter::Heavy v5.58;
  Fcntl v1.05;
  fields v2.03;
  File::Basename v2.72;
  File::Glob v1.02;
  File::Path v1.06;
  File::Spec v0.87;
  File::Spec::Unix v1.5;
  File::Temp v0.14;
  FileHandle v2.01;
  HTML::Entities v1.29;
  HTML::Mason v1.26;
  HTML::Mason::ApacheHandler v1.69;
  HTML::Mason::Exception v1.1;
  HTML::Mason::Exception::Abort v1.1;
  HTML::Mason::Exception::Compilation v1.1;
  HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
  HTML::Mason::Exception::Compiler v1.1;
  HTML::Mason::Exception::Decline v1.1;
  HTML::Mason::Exception::Params v1.1;
  HTML::Mason::Exception::Syntax v1.1;
  HTML::Mason::Exception::System v1.1;
  HTML::Mason::Exception::TopLevelNotFound v1.1;
  HTML::Mason::Exception::VirtualMethod v1.1;
  HTML::Mason::Exceptions v1.43;
  HTML::Parser v3.45;
  HTML::Scrubber v0.08;
  I18N::LangTags v0.29;
  I18N::LangTags::List v0.29;
  integer v1.00;
  IO v1.21;
  IO::File v1.10;
  IO::Handle v1.24;
  IO::InnerFile v2.110;
  IO::Lines v2.110;
  IO::Scalar v2.110;
  IO::ScalarArray v2.110;
  IO::Seekable v1.09;
  IO::Wrap v2.110;
  IO::WrapTie v2.110;
  IPC::Open2 v1.01;
  IPC::Open3 v1.0106;
  lib v0.5565;
  List::Util v1.13;
  locale v1.00;
  Locale::Maketext v1.08;
  Locale::Maketext::Fuzzy v0.02;
  Locale::Maketext::Lexicon v0.49;
  Locale::Maketext::Lexicon::Gettext v0.14;
  Log::Agent v0.306;
  Log::Dispatch v2.10;
  Log::Dispatch::Base v1.09;
  Log::Dispatch::File v1.22;
  Log::Dispatch::Output v1.26;
  Log::Dispatch::Screen v1.17;
  Log::Dispatch::Syslog v1.18;
  Mail::Address v1.62;
  Mail::Field v1.62;
  Mail::Field::AddrList v1.62;
  Mail::Field::Date v1.62;
  Mail::Header v1.62;
  Mail::Internet v1.62;
  MIME::Base64 v3.04;
  MIME::Body v5.417;
  MIME::Decoder v5.417;
  MIME::Entity v5.417;
  MIME::Field::ContDisp v5.417;
  MIME::Field::ConTraEnc v5.417;
  MIME::Field::ContType v5.417;
  MIME::Field::ParamVal v5.417;
  MIME::Head v5.417;
  MIME::Parser v5.417;
  MIME::QuotedPrint v3.03;
  MIME::Tools v5.417;
  MIME::Words v5.417;
  mod_perl v1.29;
  Module::Versions::Report v1.02;
  overload v1.01;
  Params::Validate v0.76;
  POSIX v1.08;
  re v0.04;
  Regexp::Common v2.120;
  Regexp::Common::delimited v2.104;
  RT v3.4.1;
  RT::Interface::Email v1.02;
  Scalar::Util v1.13;
  SelectSaver v1.00;
  Socket v1.77;
  Storable v2.12;
  strict v1.03;
  Symbol v1.05;
  Sys::Hostname v1.11;
  Sys::Syslog v0.05;
  Text::Autoformat v1.12;
  Text::Quoted v1.8;
  Text::Reform v1.11;
  Text::Tabs v98.112801;
  Text::Template v1.44;
  Text::WikiFormat v0.71;
  Text::Wrapper v1.000;
  Time::HiRes v1.59;
  Time::JulianDay v2003.1125;
  Time::Local v1.07;
  Time::ParseDate v2003.1126;
  Time::Timezone v2003.0211;
  Time::Zone v2.22;
  URI v1.35;
  URI::Escape v3.28;
  utf8 v1.03;
  vars v1.01;
  warnings v1.03;
  warnings::register v1.00;
  XSLoader v0.02;



RT Variables
RT::BasePath 	/usr/share/request-tracker3.4
RT::BinPath 	/usr/bin
RT::CORE_CONFIG_FILE 	/etc/request-tracker3.4/RT_Config.pm
RT::CanonicalizeEmailAddressMatch 	elabx.xxx.de$
RT::CanonicalizeEmailAddressReplace 	xxx.de
RT::CommentAddress 	ssc-comment at xxx.de
RT::CorrespondAddress 	ssc at xxx.de
RT::DatabaseHost 	localhost
RT::DatabaseName 	rt34
RT::DatabasePassword 	Password not printed
RT::DatabaseRTHost 	localhost
RT::DatabaseType 	mysql
RT::DatabaseUser 	rt_user
RT::DateDayBeforeMonth 	1
RT::DefaultSearchResultFormat 	'<B><A HREF="/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#', '<B><A HREF="/Ticket/Display.html?id=__id__">__Subject__</a></B>/TITLE:Subject', Status, QueueName, OwnerName, Priority, '__NEWLINE__', '', '<small>__Requestors__</small>', '<small>__CreatedRelative__</small>', '<small>__ToldRelative__</small>', '<small>__LastUpdatedRelative__</small>', '<small>__TimeLeft__</small>'
RT::DropLongAttachments 	1
RT::EmailOutputEncoding 	iso-8859-1
RT::EtcPath 	/etc/request-tracker3.4
RT::FriendlyFromLineFormat 	"%s (SSC)" <%s>
RT::FriendlyToLineFormat 	"%s (SSC) Ticket #%s":;
RT::LocalEtcPath 	/usr/local/share/request-tracker3.4/etc
RT::LocalLexiconPath 	/usr/local/share/request-tracker3.4/po
RT::LocalPath 	/usr/local/share/request-tracker3.4
RT::LogDir 	/var/log/request-tracker3.4
RT::LogToFile 	info
RT::LogToFileNamed 	rt.log
RT::LogToScreen 	error
RT::LogToSyslog 	error
RT::LogoURL 	https://xxx.de/NoAuth/images/ssc_logo.gif
RT::LoopsToRTOwner 	1
RT::MailCommand 	sendmailpipe
RT::MasonComponentRoot 	/usr/share/request-tracker3.4/html
RT::MasonDataDir 	/var/cache/request-tracker3.4/mason_data
RT::MasonLocalComponentRoot 	/usr/local/share/request-tracker3.4/html
RT::MasonSessionDir 	/var/cache/request-tracker3.4/session_data
RT::MaxAttachmentSize 	500000
RT::MaxInlineBody 	13456
RT::MessageBoxWidth 	72
RT::MessageBoxWrap 	HARD
RT::MinimumPasswordLength 	5
RT::MyRequestsLength 	10
RT::MyTicketsLength 	10
RT::Organization 	xxx.de
RT::OwnerEmail 	mm at xxx.de
RT::ParseNewMessageForTicketCcs 	1
RT::RTAddressRegexp 	^ssc\@xxx.de$
RT::RecordOutgoingEmail 	1
RT::RedistributeAutoGeneratedMessages 	1
RT::SITE_CONFIG_FILE 	/etc/request-tracker3.4/RT_SiteConfig.pm
RT::SendmailArguments 	-oi -t -f postmaster at elabnet.com
RT::SendmailPath 	/usr/sbin/sendmail
RT::Timezone 	Europe/Berlin
RT::UseFriendlyFromLine 	1
RT::VERSION 	3.4.1
RT::VarPath 	/var/cache/request-tracker3.4
RT::WebBaseURL 	https://xxx.de
RT::WebExternalAuth 	true
RT::WebFallbackToInternalAuth 	true
RT::WebFlushDbCacheEveryRequest 	1
RT::WebImagesURL 	https://xxx.de/NoAuth/images/
RT::WebURL 	https://xxx.de/
RT::rtname 	SSC
Perl configuration

Summary of my perl5 (revision 5 version 8 subversion 4) configuration:
  Platform:
    osname=linux, osvers=2.6.15, archname=i386-linux-thread-multi
    uname='linux ninsei 2.6.15 #1 smp preempt sat jan 7 12:47:52 pst 2006 i686 gnulinux '
    config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN -Dcccdlflags=-fPIC -Darchname=i386-linux -Dprefix=/usr -Dprivlib=/usr/share/perl/5.8 -Darchlib=/usr/lib/perl/5.8 -Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5 -Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local -Dsitelib=/usr/local/share/perl/5.8.4 -Dsitearch=/usr/local/lib/perl/5.8.4 -Dman1dir=/usr/share/man/man1 -Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1 -Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl -Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Uusesfio -Uusenm -Duseshrplib -Dlibperl=libperl.so.5.8.4 -Dd_dosuid -des'
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=undef use64bitall=undef uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
    optimize='-O2',
    cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -I/usr/local/include'
    ccversion='', gccversion='3.3.5 (Debian 1:3.3.5-13)', gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
    alignbytes=4, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -L/usr/local/lib'
    libpth=/usr/local/lib /lib /usr/lib
    libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
    perllibs=-ldl -lm -lpthread -lc -lcrypt
    libc=/lib/libc-2.3.2.so, so=so, useshrplib=true, libperl=libperl.so.5.8.4
    gnulibc_version='2.3.2'
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
    cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'

More information about the rt-users mailing list