Springle has submitted this change and it was merged. Change subject: This was turned off for wikidata queries on wb_terms. However it caused a parformance hit for an ipblocks query on enwiki. Latter trumps former. Revert and find another way... ......................................................................
This was turned off for wikidata queries on wb_terms. However it caused a parformance hit for an ipblocks query on enwiki. Latter trumps former. Revert and find another way... Change-Id: Iaeddf84229cb72355e45f38c150111328de53184 --- M modules/coredb_mysql/templates/prod.my.cnf.erb 1 file changed, 1 insertion(+), 1 deletion(-) Approvals: Springle: Looks good to me, approved jenkins-bot: Verified diff --git a/modules/coredb_mysql/templates/prod.my.cnf.erb b/modules/coredb_mysql/templates/prod.my.cnf.erb index 84ed1cb..b8fa52f 100644 --- a/modules/coredb_mysql/templates/prod.my.cnf.erb +++ b/modules/coredb_mysql/templates/prod.my.cnf.erb @@ -71,7 +71,7 @@ collation_server=binary log_slow_verbosity=Query_plan -optimizer_switch='mrr=on,mrr_cost_based=on,mrr_sort_keys=on,optimize_join_buffer_size=on,extended_keys=off,index_merge_sort_union=off' +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 -- To view, visit https://gerrit.wikimedia.org/r/107366 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: Iaeddf84229cb72355e45f38c150111328de53184 Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Springle <[email protected]> Gerrit-Reviewer: Springle <[email protected]> Gerrit-Reviewer: jenkins-bot _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
