From 461a94440f4e6a913a1318d32c6d1fddc20f4281 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Oliver=20B=C3=B6ttcher?= <oliver.boettcher@pixelpark.com>
Date: Tue, 18 Oct 2016 10:47:44 +0200
Subject: [PATCH] wissenschaftsjahr: mysql tuning

---
 customer/bmbf/web02-bmbf.pixelpark.net.yaml | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/customer/bmbf/web02-bmbf.pixelpark.net.yaml b/customer/bmbf/web02-bmbf.pixelpark.net.yaml
index e0a79384..8e5286ec 100644
--- a/customer/bmbf/web02-bmbf.pixelpark.net.yaml
+++ b/customer/bmbf/web02-bmbf.pixelpark.net.yaml
@@ -16,6 +16,16 @@ php::extensions:
   xml: {}
   pecl-zip: {}
 
+mysql::server::override_options:
+  mysqld:
+    innodb_buffer_pool_size: 2G
+    innodb_buffer_pool_instances: 3
+    memlock: true
+    thread_pool_size: 16
+    innodb_log_buffer_size: 16M
+    query_cache_type: 0
+    default-storage-engine: INNODB
+
 site::profile::apache::htdigest:
   server:
     www: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAlueJBABHUQ1vFyTLoXRXMDQGtkR34+hMZVR+rct9gTye+20o7tKRI8b2c11FYRf6Zk5VHmfJUMgUKja9CnItVa9SzDhmMwCHw+Z7c3jVfWdR1sHl3MJ7yP+1FwKztMOCJzLBZ8nxp/YJgmtgHNnbGxG3Eu/lyxreiCDB96V0IQuqQuHutBcX/r8AFapZQb2MoJWqOPe2h4kfnxJGLdDaLF/E7uAV3K2y3wrj4+RczDKnGIwbjCi0DrdJx11NdkJEK526bQIMFHZbKj4QlAJn4/zx8qMgdkJvx2VHLJMe8gXyJzP3/tQtF143RvxHgxYScBz5mfPtsjFn3q8wQXjSxDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCCGKZkyaN5l3UuTLHKJv3IgCB6twTZNGBijlT/8dHjfRHFH0CgaWiY5C4P2Q1MF8TZxw==]
-- 
2.39.5