Improve mysqld server configuration
Our current innodb_buffer_pool_size is set to 64 MB in the role, while the upstream default size is 128 MB and according to some posts this value can easily be set higher if enough ram is available.
In short, we should re-evaluate our defaults:
-
innodb_data_file_path = ibdata1:10M:autoextend -
innodb_buffer_pool_size = 64M -
innodb_log_file_size = 64M -
innodb_log_buffer_size = 8M -
innodb_flush_log_at_trx_commit = 1 -
innodb_stats_sample_pages = 32 -
innodb_thread_concurrency = 8 -
innodb_file_per_table -
table_open_cache = 64
An idea is to dump the flyspray db (400MB) in size and benchmark it with different settings in a VM to replicate the ram values we have in a live system.
Edited by Sven-Hendrik Haase