From 438d2d2b3adcd4916fcb112bc31527a1f45a5fe4 Mon Sep 17 00:00:00 2001 From: schneefux Date: Fri, 23 Jun 2017 17:42:49 +0200 Subject: tweak params for performance --- docker-compose.yml | 3 ++- mariadb/performance_tuning.cnf | 10 +++++++++- 2 files changed, 11 insertions(+), 2 deletions(-) diff --git a/docker-compose.yml b/docker-compose.yml index 6720d4d..c311de6 100644 --- a/docker-compose.yml +++ b/docker-compose.yml @@ -302,7 +302,8 @@ services: - RABBITMQ_URI=amqp://cruncher:cruncher@vaindock_queue/ - DATABASE_URI=mysql://vainweb:vainweb@vaindock_db-web/vainweb - QUEUE=crunch - - SLOWMODE=100 + - BATCHSIZE=100 + - SLOWMODE=0 vaindock_cruncher_tournament: build: ../cruncher diff --git a/mariadb/performance_tuning.cnf b/mariadb/performance_tuning.cnf index ec26735..2700bb1 100644 --- a/mariadb/performance_tuning.cnf +++ b/mariadb/performance_tuning.cnf @@ -1,3 +1,11 @@ [mysqld] innodb_buffer_pool_size = 8G -innodb_flush_log_at_trx_commit=2 +innodb_log_buffer_size = 512M +innodb_log_file_size = 128M +innodb_write_io_threads = 16 +innodb_flush_log_at_trx_commit = 2 + +# SSD tweaks +innodb_checksum_algorithm = crc32 +innodb_flush_neighbors = 0 +innodb_io_capacity = 1000 -- cgit v1.3.1