Asher has submitted this change and it was merged.
Change subject: reduce bufferpool size on labsdb s1 slave, set
max_user_connections = 10 for all labs instances
......................................................................
reduce bufferpool size on labsdb s1 slave, set max_user_connections = 10 for
all labs instances
Change-Id: Idfb78d5a1dc6074f4d4fb699c79f254bec246713
---
M manifests/site.pp
M modules/mysql_multi_instance/manifests/instance.pp
2 files changed, 3 insertions(+), 2 deletions(-)
Approvals:
Asher: Verified; Looks good to me, approved
jenkins-bot: Verified
diff --git a/manifests/site.pp b/manifests/site.pp
index 8cd373f..4255020 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -1228,7 +1228,7 @@
's1' => {
'port' => 3306,
'innodb_log_file_size' => "2000M",
- 'ram' => "151G",
+ 'ram' => "120G",
'innodb_locks_unsafe_for_binlog' => true,
'repl_ignore_dbs' => 'mysql',
'slave_transaction_retries' => 100000,
diff --git a/modules/mysql_multi_instance/manifests/instance.pp
b/modules/mysql_multi_instance/manifests/instance.pp
index 65d02e4..a51b929 100644
--- a/modules/mysql_multi_instance/manifests/instance.pp
+++ b/modules/mysql_multi_instance/manifests/instance.pp
@@ -122,7 +122,8 @@
'max_allowed_packet' => "16M",
'thread_stack' => "192K",
'thread_cache_size' => 300,
- 'max_connections' => 5000,
+ 'max_connections' => 2000,
+ 'max_user_connections' => 10,
'table_open_cache' => 50000,
'table_definition_cache' => 40000,
'query_cache_size' => 0,
--
To view, visit https://gerrit.wikimedia.org/r/69422
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Idfb78d5a1dc6074f4d4fb699c79f254bec246713
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Asher <afeld...@wikimedia.org>
Gerrit-Reviewer: Asher <afeld...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
