Springle has uploaded a new change for review. https://gerrit.wikimedia.org/r/96013
Change subject: try to stabilize innodb index cardinality ...................................................................... try to stabilize innodb index cardinality Change-Id: I13166c65c2afa85cd84e93c46fc6e5f93c66e241 --- M modules/coredb_mysql/templates/prod.my.cnf.erb 1 file changed, 7 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/13/96013/1 diff --git a/modules/coredb_mysql/templates/prod.my.cnf.erb b/modules/coredb_mysql/templates/prod.my.cnf.erb index 633b881..f2457be 100644 --- a/modules/coredb_mysql/templates/prod.my.cnf.erb +++ b/modules/coredb_mysql/templates/prod.my.cnf.erb @@ -104,6 +104,13 @@ innodb-write-io-threads=8 innodb-checksums=1 +# try to improve innodb index cardinality accuracy on large tables +# might need to be even higher and innodb_stats_on_metadata=OFF +innodb_stats_sample_pages = 16 + +# encourage more ref lookups when joining tables with nullable fields +innodb_stats_method = nulls_unequal + <% if innodb_file_per_table == true then -%> innodb_file_per_table <% end -%> -- To view, visit https://gerrit.wikimedia.org/r/96013 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I13166c65c2afa85cd84e93c46fc6e5f93c66e241 Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Springle <sprin...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits