diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-06-23 17:42:49 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-06-23 17:42:49 +0200 |
| commit | 438d2d2b3adcd4916fcb112bc31527a1f45a5fe4 (patch) | |
| tree | faffb73e346788db130aca8eaea6fe5338e7192a | |
| parent | ccb8726e855a38d084a874a7f6794d0972a6e582 (diff) | |
| download | vaindock-438d2d2b3adcd4916fcb112bc31527a1f45a5fe4.tar.gz vaindock-438d2d2b3adcd4916fcb112bc31527a1f45a5fe4.zip | |
tweak params for performancerelease/2.8.0
| -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 |