Performance Issues RT3 (following some other treats)

RT Users
1

Hi @All,

ok, now the most of the configuration problems are fixed, but the new system
is slow!!! Have anyone some system values or settings for fastcgi, mysql and
so on?

OK, what have i done, which test i have made and how is my test environment:

  1. Starting with our old RT2

Its based on a:

  • PIII-500 with 700 MB RAM
  • Apache 1.3
  • mod_perl 1.26
  • MySQL 3.23
  • RT2
  • 6000 Users
  • 40.000 Tickets in Database
  • OK, not bad for an old system with 200 currently working user on it. But
    its very slow, too slow to work with it.
  1. Coming to our new environment:
  • Single Pentium IV Xeon with 2 GB RAM
  • Apache 2.0.48
  • FastCGI
  • MySQL 4
  • RT3
  • 6000 Users
  • 40000 Tickets
  • Only one user working on the box !
  • OK, its faster, but only with one User!!!
  1. Same with a dual prozessor Box:
  • Dual Pentium IV Xeon with 2 GB RAM
  • Apache 2.0.48
  • FastCGI
  • MySQL 4
  • RT3
  • 6000 Users
  • 40000 Tickets
  • Only one user working on the box !

Tests Pentium III / 500 Single Pentium 4 Dual Pentium 4

Press CREATE Ticket 11 sec 1 sec 1 sec
Submit New Ticket 3 sec 4 sec 3 sec

Press Reply Ticket 15 sec 1 sec 1 sec
Submit Reply Ticket 6 sec 6 sec 3 sec

Press Resolve Ticket 24 sec 1 sec 1 sec
Submit Resolve Ticket 3 sec 5 sec 3 sec

Press Create Ticket 17 sec 2 sec 1 sec
Submit Ticket with Attachment 15 sec 16 sec 9 sec
(1,7 MB)

Search for Ticket 2 sec 3 sec 2 sec
Search for Username 13 sec 4 sec 3 sec

Now my configuration:

Apache: httpd.conf

LoadModule fastcgi_module /usr/lib/httpd/modules/mod_fastcgi.so
FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 300 -processes
20 -listen-queue-depth 200 -priority 10
<VirtualHost *>
ServerName ticket-new.company.com
ServerAdmin support@company.com
DocumentRoot /opt/rt3/share/html
AddHandler fastcgi-script .fcgi
Alias /NoAuth/images/ /opt/rt3/share/html/NoAuth/images/
ScriptAlias / /opt/rt3/bin/mason_handler.fcgi/

MySQL: my.cnf (copied from the my-huge.cnf

[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 10M
table_cache = 512
sort_buffer_size = 20M
read_buffer_size = 20M
myisam_sort_buffer_size = 128M
thread_cache = 64
query_cache_size = 64M
thread_concurrency = 8
[mysqldump]
quick
max_allowed_packet = 32M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 20M
write_buffer = 20M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 20M
write_buffer = 20M
[mysqlhotcopy]
interactive-timeout

OK, so far, so good. I have heard something about performance tips and
reindexing mysql database, where can i get mor information about this ?!

Kind Regards

Torsten Brumm