[rt-users] Performance Issues RT3 (following some other treats)

[HAM MI-IH / Torsten Brumm]

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.

2. 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!!!

3. 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 at 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/
</VirtualHost>

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