[rt-users] RT3 is very slow (Tom?? Hur?n) - my config

[Paul D. Eden]

Thank you.  That is just what I needed.

Paul

On Thu, 2004-03-18 at 09:49, HAM MI-IH / Torsten Brumm wrote:
> Hi Tom, Hi Mailing List,
> 
> attached our config for:
> 
> 1. MySQL 4
> 2. Apache (FastCGI)
> 
> 1. MySQL - my.cnf
> 
> # The following options will be passed to all MySQL clients
> [client]
> #password       = your_password
> port            = 3306
> socket          = /var/lib/mysql/mysql.sock
> 
> # Here follows entries for some specific programs
> 
> # The MySQL server
> [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
> # Try number of CPU's*2 for thread_concurrency
> thread_concurrency = 16
> 
> log-bin
> 
> server-id       = 1
> 
> [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
> 
> #innodb settings
> innodb_data_file_path = ibdata1:255M:autoextend
> set-variable = innodb_buffer_pool_size=256M
> set-variable = innodb_additional_mem_pool_size=64M
> set-variable = innodb_log_file_size=80M
> set-variable = innodb_log_buffer_size=32M
> set-variable = innodb_flush_log_at_trx_commit=1
> set-variable = read_buffer_size=32M
> set-variable = sort_buffer=32M
> 
> 2. Apache config
> 
> LoadModule fastcgi_module /usr/lib/httpd/modules/mod_fastcgi.so
> 
> # This is the FastCGI Server for RT3
> FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 150 -processes
> 120 -listen-queue-depth 200 -priority 10
> 
> <VirtualHost *>
>         ServerName ticket.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>
> 
> This works very well for us!