[rt-devel] Re: [rt-users] RT 3.0.3 - Sudden MySQL slowness

[Harald Wagener]

So, further investigation shows that the MySQL queries are slowed down
to death. Setting the idle-timeout for the FastCgiServer to 120 seconds,
the internal server errors don't pop up anymore. The MySQL queries take
about 80 seconds to complete in the first run, and are stunningly fast
being served out of the query cache.

I read some of the documentation about MySQL tuning, and set the
following variables for a machine with 640 Megabyte of RAM which mainly
does serve our intranet website, RT, and cups:

skip-locking
#primary optimisation variables
set-variable = key_buffer=128M
set-variable = table_cache=256
set-variable = thread_cache=8
set-variable = thread_concurrency=2
#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
#query cache settings
set-variable = query_cache_size=128M
set-variable = query_cache_type=1

Anything else there is to watch out for?

Regards,
    Harald