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 /mariadb/performance_tuning.cnf | |
| parent | ccb8726e855a38d084a874a7f6794d0972a6e582 (diff) | |
| download | vaindock-release/2.8.0.tar.gz vaindock-release/2.8.0.zip | |
tweak params for performancerelease/2.8.0
Diffstat (limited to 'mariadb/performance_tuning.cnf')
| -rw-r--r-- | mariadb/performance_tuning.cnf | 10 |
1 files changed, 9 insertions, 1 deletions
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 |