diff options
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 |