Asher has uploaded a new change for review.
https://gerrit.wikimedia.org/r/55834
Change subject: found another mariadb performance regression with extended_keys
......................................................................
found another mariadb performance regression with extended_keys
Change-Id: I6509960d77915d309c03aac75b56804e15f1fa39
---
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/34/55834/1
diff --git a/modules/coredb_mysql/templates/prod.my.cnf.erb
b/modules/coredb_mysql/templates/prod.my.cnf.erb
index 72dd962..50146aa 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='mrr=on,mrr_cost_based=on,mrr_sort_keys=on,optimize_join_buffer_size=on,extended_keys=on'
+optimizer_switch='mrr=on,mrr_cost_based=on,mrr_sort_keys=on,optimize_join_buffer_size=on,extended_keys=off'
+#thread_handling=pool-of-threads
+#extra_port=3308
<% else %>
rpl_transaction_enabled
reserved_super_connections=20
--
To view, visit https://gerrit.wikimedia.org/r/55834
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I6509960d77915d309c03aac75b56804e15f1fa39
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Asher <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
