From: Tom Hughes <tom@compton.nu>
Date: Sat, 25 Feb 2017 18:04:14 +0000 (+0000)
Subject: Enable query cache for mediawiki machines
X-Git-Url: https://git.openstreetmap.org/chef.git/commitdiff_plain/f12949b32dbf868a911b64a16cf74bd38e775d49

Enable query cache for mediawiki machines
---

diff --git a/roles/foundation.rb b/roles/foundation.rb
index 7d46dc748..f306fe925 100644
--- a/roles/foundation.rb
+++ b/roles/foundation.rb
@@ -31,6 +31,7 @@ default_attributes(
         :key_buffer_size => "64M",
         :max_connections => "200",
         :query_cache_size => "48M",
+        :query_cache_type => "1",
         :sort_buffer_size => "8M",
         :tmp_table_size => "48M"
       }
diff --git a/roles/wiki.rb b/roles/wiki.rb
index edb21ab29..38aa6cd5c 100644
--- a/roles/wiki.rb
+++ b/roles/wiki.rb
@@ -52,6 +52,7 @@ default_attributes(
         :key_buffer_size => "64M",
         :max_connections => "200",
         :query_cache_size => "256M",
+        :query_cache_type => "1",
         :sort_buffer_size => "8M",
         :tmp_table_size => "128M"
       }