From 438d2d2b3adcd4916fcb112bc31527a1f45a5fe4 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Fri, 23 Jun 2017 17:42:49 +0200
Subject: tweak params for performance

---
 mariadb/performance_tuning.cnf | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

(limited to 'mariadb')

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