Nikerabbit has uploaded a new change for review.
https://gerrit.wikimedia.org/r/280436
Change subject: Tweak mysql settings and install mysql on es
......................................................................
Tweak mysql settings and install mysql on es
Experimenting to reduce some pressure on the db.
Change-Id: Ic4956d550c6f6d2416e467b6c5603b4aa0d6613d
---
M puppet/modules/mariadb/manifests/init.pp
M puppet/site.pp
2 files changed, 7 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/translatewiki
refs/changes/36/280436/1
diff --git a/puppet/modules/mariadb/manifests/init.pp
b/puppet/modules/mariadb/manifests/init.pp
index 7cde26b..42979a6 100644
--- a/puppet/modules/mariadb/manifests/init.pp
+++ b/puppet/modules/mariadb/manifests/init.pp
@@ -10,16 +10,18 @@
mysqld => {
character-set-server => 'utf8',
innodb_additional_mem_pool_size => '400M',
+ innodb_buffer_pool_instances => '12',
innodb_buffer_pool_size => '12G',
innodb_file_per_table => '1',
innodb_log_file_size => '500M',
- key_buffer_size => '64M',
+ thread_pool_size => '16',
+ key_buffer_size => '16M',
log_slow_queries => '/var/log/mysql/mysql-slow.log',
- long_query_time => '1',
+ long_query_time => '60',
query_cache_size => '0',
query_cache_type => '0',
ssl => '0',
- table_cache => '750'
+ table_cache => '1500'
},
client => {
default-character-set => 'utf8'
diff --git a/puppet/site.pp b/puppet/site.pp
index 352975b..2842c09 100644
--- a/puppet/site.pp
+++ b/puppet/site.pp
@@ -52,4 +52,6 @@
include eximconf
include eximconf::es
include profile::mwelasticsearch
+
+ include mariadb
}
--
To view, visit https://gerrit.wikimedia.org/r/280436
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic4956d550c6f6d2416e467b6c5603b4aa0d6613d
Gerrit-PatchSet: 1
Gerrit-Project: translatewiki
Gerrit-Branch: master
Gerrit-Owner: Nikerabbit <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
