Jcrespo has uploaded a new change for review.

  https://gerrit.wikimedia.org/r/249385

Change subject: Increase the host and account size on P_S config
......................................................................

Increase the host and account size on P_S config

As we have more hosts than usual connecting to mysql, 100 slots
in performance_schema configuration are not enough to contain all
hosts and users. Increasing it to 300, which should be enough for
all our clients per datacenter.

Change-Id: Ic2e1fef6e3ca4e24872e357761fc41426290450f
References: T99485
---
M templates/mariadb/production.my.cnf.erb
1 file changed, 2 insertions(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/85/249385/1

diff --git a/templates/mariadb/production.my.cnf.erb 
b/templates/mariadb/production.my.cnf.erb
index e668b4c..43b207f 100644
--- a/templates/mariadb/production.my.cnf.erb
+++ b/templates/mariadb/production.my.cnf.erb
@@ -94,7 +94,8 @@
 performance_schema_digests_size = -1
 performance_schema_max_thread_instances = 500
 performance_schema_max_cond_instances = 1000
-performance_schema_accounts_size = 100
+performance_schema_accounts_size = 300
+performance_schema_hosts_size = 300
 performance_schema_events_statements_history_size = 10
 performance_schema_events_statements_history_long_size = 1000
 performance_schema_events_waits_history_size = 10

-- 
To view, visit https://gerrit.wikimedia.org/r/249385
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic2e1fef6e3ca4e24872e357761fc41426290450f
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <[email protected]>

_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to