Springle has uploaded a new change for review.
https://gerrit.wikimedia.org/r/107994
Change subject: Disable slow information_schema query that scans all databases
and tables.
......................................................................
Disable slow information_schema query that scans all databases and tables.
RT 6639
This query corresponds with bursts of slow queries showing up on ishamel
for s3 and s7 hosts (shards with more wikis and therefore the most tables).
Also slow on special slaves running paritioned tables. Need to find another
way...
Change-Id: I2ac3ed1702cf56274c45f36b9a8bed91a1981625
---
M modules/mysql_wmf/templates/mysql.pyconf.erb
1 file changed, 3 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/94/107994/1
diff --git a/modules/mysql_wmf/templates/mysql.pyconf.erb
b/modules/mysql_wmf/templates/mysql.pyconf.erb
index 3a40127..4ac49de 100644
--- a/modules/mysql_wmf/templates/mysql.pyconf.erb
+++ b/modules/mysql_wmf/templates/mysql.pyconf.erb
@@ -217,9 +217,9 @@
# This reports free space in the first free innodb table found
# that the ganglia (dbstats) users has select access to.
# Normally this is non, so a grant must be made to enable this.
- metric {
- name = "mysql_innodb_free_space"
- }
+ # metric {
+ # name = "mysql_innodb_free_space"
+ # }
metric {
name = "mysql_binlog_space_used"
--
To view, visit https://gerrit.wikimedia.org/r/107994
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I2ac3ed1702cf56274c45f36b9a8bed91a1981625
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Springle <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
