[Rt-users] RT 3.0.10 performance
Arnold Cavazos Jr.
abcjr at abcjr.net
Fri Apr 16 14:29:48 EDT 2004
I feel your pain.
I have a theory...
Care to send the output of:
cat /proc/sys/kernel/shmall
cat /proc/sys/kernel/shmmax
/usr/bin/ipcs -a
/usr/bin/uname -a
to either the list or to me directly?
--
Arnold Cavazos, Jr. abcjr at abcjr . net
On Tue, Apr 13, 2004 at 06:12:02PM -0700, Dan O'Neill wrote:
> RT users,
>
> I'd like to chime in on the RT performance issue. First, understand that
> I think RT is the best ticketing system that I've ever had the pleasure of
> using. Second, there is something about RT that is slow and it's not the
> database. Third, this is a long message so I apologize in advance, but I
> want to present all the necessary information.
>
> And last, I'm looking to work with someone and try different things to
> make this product faster. I'm willing to do some profiling work as well.
>
>
> Configuration information:
> Hardware:
> Dual 1GHZ Pentium pro
> 1GB RAM
> 1000rpm 36GB scsi
> 100mbps Intel NIC
>
> Operating system:
> Fedora Core 1
> All RT required modules installed
> EXT 3 file system on all partitions
>
> Output from top:
>
> 17:53:20 up 8 days, 9:18, 1 user, load average: 0.00, 0.00, 0.00
> 72 processes: 71 sleeping, 1 running, 0 zombie, 0 stopped
> CPU states: cpu user nice system irq softirq iowait idle
> total 0.0% 0.0% 2.8% 0.0% 0.0% 0.0% 197.0%
> cpu00 0.0% 0.0% 2.9% 0.0% 0.0% 0.0% 97.0%
> cpu01 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
> Mem: 1032040k av, 707972k used, 324068k free, 0k shrd, 103720k
> buff 230444k active, 378380k inactive
> Swap: 514072k av, 0k used, 514072k free 211692k cached
>
>
> Apache process size:
>
> PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
> 11092 root 16 0 23176 22M 10796 S 0.0 2.2 100:09 1 httpd
>
> Users:
> Maybe 5 people use it on a daily basis
>
> # of Tickets:
> 150 as of 3/4/04
>
> Now, look at a queue with 20 NEW tickets. Select the NEW tickets from
> the queue list, press next, and Apache starts to use a tremendous amount
> of CPU to present the ticket. It's not just this sequence either, it's any
> sequence of events that result in information being retrieved.
>
> PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
> 11092 root 16 0 23176 22M 10796 S 96.4 2.2 101:19 0 httpd
>
>
> This is a regular occurance. The system is dedicated to RT. Here is the
> relevant Apache configuration information:
>
> Apache/1.3.29 (Unix) mod_perl/1.29 mod_ssl/2.8.16 OpenSSL/0.9.7a
>
> MinSpareServers 5
> MaxSpareServers 10
> StartServers 5
> MaxClients 150
> MaxRequestsPerChild 0
>
> <VirtualHost *:80>
> ServerName rt.xyzzy.com
> DocumentRoot /opt/rt3010/share/html
>
> PerlModule Apache::DBI
>
> PerlRequire /opt/rt3010/bin/webmux.pl
>
> <Location />
> SetHandler perl-script
> PerlHandler RT::Mason
> </Location>
>
> ErrorLog /usr/local/www/logs/error_log
> TransferLog /usr/local/www/logs/access_log
>
> </VirtualHost>
>
>
> Database configuration:
>
> postgresql-7.3.4-11
> postgresql-server-7.3.4-11
> postgresql-libs-7.3.4-11
> postgresql-devel-7.3.4-11
> postgresql-odbc-7.3-4
>
> There is NO load on the database. A listing of active queries
> doesn't even begin to show any long running transactions. So
> please, don't tell me to use mysql because it's faster. There's
> no database load at all, it's the stuff in Apache that's slow.
>
>
> Let me know how I can help make RT faster. Two 1GHZ processors should be
> plenty of horse power to run a system such as this.
>
> Regards,
>
> dan
>
>
>
> _______________________________________________
> RT-Users mailing list
> RT-Users at lists.bestpractical.com
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
More information about the rt-users
mailing list