[rt-users] RT 3.0 Speed

[Autrijus Tang]

On Tue, May 06, 2003 at 01:52:50PM +0100, Simon Woodward wrote:
> MySQL specific configuration:
> 
> datadir=/usr/local/var/mysql
> innodb_data_file_path=ibdata1:10M:autoextend:max:2000M
> innodb_buffer_pool_size=128M
> innodb_additional_mem_pool_size=32M
> innodb_log_buffer_size=8M
> innodb_flush_log_at_trx_commit=1

Here's my config for the Win32 binary distributoni of RT,
and the performance is rather good (on mysql 4.0.1x):

my %Conf = (
    key_buffer_size			=> '256M',
    table_cache				=> '64',

    query_cache_size			=> '4M',
    max_allowed_packet			=> '1M',
    sort_buffer				=> '1M',
    record_buffer			=> '1M',

    innodb_buffer_pool_size		=> '256M',
    innodb_additional_mem_pool_size	=> '20M',
);

The first two are arguably the most important pair; did you
forget to set them?

/Autrijus/