Springle has submitted this change and it was merged. Change subject: Default temporary and custom tables to Aria engine for Analytics. Won't affect upstream schema changes and does not prevent researchers using InnoDB or TokuDB explicitly. ......................................................................
Default temporary and custom tables to Aria engine for Analytics. Won't affect upstream schema changes and does not prevent researchers using InnoDB or TokuDB explicitly. Change-Id: I45bab4d95f62824e1b935dd212e88b5bfc5eb633 --- M templates/mariadb/analytics.my.cnf.erb 1 file changed, 4 insertions(+), 1 deletion(-) Approvals: Springle: Looks good to me, approved jenkins-bot: Verified diff --git a/templates/mariadb/analytics.my.cnf.erb b/templates/mariadb/analytics.my.cnf.erb index 7cd1eb4..ef92e05 100644 --- a/templates/mariadb/analytics.my.cnf.erb +++ b/templates/mariadb/analytics.my.cnf.erb @@ -38,6 +38,10 @@ character_set_filesystem = binary collation_server = binary +# Analysts love creating temporary tables +default_storage_engine = Aria +aria_pagecache_buffer_size = 1G + transaction-isolation = READ-COMMITTED innodb_file_per_table = 1 innodb_buffer_pool_size = 4G @@ -45,7 +49,6 @@ innodb_flush_log_at_trx_commit = 0 innodb_flush_method = O_DIRECT innodb_locks_unsafe_for_binlog = 1 -aria_pagecache_buffer_size = 1G optimizer_switch='engine_condition_pushdown=on,optimize_join_buffer_size=on' join_cache_level = 8 -- To view, visit https://gerrit.wikimedia.org/r/131024 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I45bab4d95f62824e1b935dd212e88b5bfc5eb633 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
