Asher has uploaded a new change for review.
https://gerrit.wikimedia.org/r/51781
Change subject: mariadb query optimizer tuning
......................................................................
mariadb query optimizer tuning
Change-Id: I2c8e31cb3bc1bcdf6d2d2e654f6cbdb889d34e2a
---
M modules/coredb_mysql/templates/prod.my.cnf.erb
1 file changed, 3 insertions(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/81/51781/1
diff --git a/modules/coredb_mysql/templates/prod.my.cnf.erb
b/modules/coredb_mysql/templates/prod.my.cnf.erb
index 4959695..8a80067 100644
--- a/modules/coredb_mysql/templates/prod.my.cnf.erb
+++ b/modules/coredb_mysql/templates/prod.my.cnf.erb
@@ -65,7 +65,9 @@
<% if has_variable?("mariadb") and mariadb == true then -%>
query_cache_type=0
log_slow_verbosity=Query_plan
-optimizer_switch='extended_keys=on'
+# extended_keys disabled until https://mariadb.atlassian.net/browse/MDEV-4220
is fixed
+# optimizer_switch='extended_keys=on'
+optimizer_switch='mrr=on,mrr_cost_based=on,mrr_sort_keys=on,optimize_join_buffer_size=on'
<% else %>
rpl_transaction_enabled
reserved_super_connections=20
--
To view, visit https://gerrit.wikimedia.org/r/51781
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I2c8e31cb3bc1bcdf6d2d2e654f6cbdb889d34e2a
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Asher <afeld...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
