Asher has uploaded a new change for review.
https://gerrit.wikimedia.org/r/59187
Change subject: binary character and collation defaults for mariadb
......................................................................
binary character and collation defaults for mariadb
Change-Id: Iea4b4a8495fd0f8a4a05535a33a4d742adb07ea8
---
M modules/coredb_mysql/templates/prod.my.cnf.erb
1 file changed, 6 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/87/59187/1
diff --git a/modules/coredb_mysql/templates/prod.my.cnf.erb
b/modules/coredb_mysql/templates/prod.my.cnf.erb
index fc017bc..db16d4d 100644
--- a/modules/coredb_mysql/templates/prod.my.cnf.erb
+++ b/modules/coredb_mysql/templates/prod.my.cnf.erb
@@ -64,6 +64,12 @@
<% if has_variable?("mariadb") and mariadb == true then -%>
query_cache_type=0
+
+# these were set as compile time defaults in our mysql builds
+character_set_server=binary
+character_set_filesystem=binary
+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'
#thread_handling=pool-of-threads
--
To view, visit https://gerrit.wikimedia.org/r/59187
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Iea4b4a8495fd0f8a4a05535a33a4d742adb07ea8
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
