diff options
| -rw-r--r-- | docker-compose.yml | 3 | ||||
| -rw-r--r-- | 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 |