Marostegui has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/394527 )
Change subject: mariadb: Enable Barracuda on a few roles ...................................................................... mariadb: Enable Barracuda on a few roles Let's start deploying Barracuda as default format for a few roles. Specially those getting benefits from the compression Bug: T150949 Change-Id: Ieff4181739e497453afcd6a96602b2ac2ad1b83c --- M modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb M modules/role/templates/mariadb/mysqld_config/dbstore_multiinstance.my.cnf.erb M modules/role/templates/mariadb/mysqld_config/sanitarium_multiinstance.my.cnf.erb 3 files changed, 3 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/27/394527/1 diff --git a/modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb b/modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb index 6e166ce..b6ca61d 100644 --- a/modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb +++ b/modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb @@ -124,6 +124,7 @@ innodb_stats_sample_pages = 16 innodb_stats_method = nulls_unequal innodb_locks_unsafe_for_binlog = 1 +innodb_file_format = barracuda # dump and load innodb buffer at start and stop innodb_buffer_pool_load_at_startup = 1 diff --git a/modules/role/templates/mariadb/mysqld_config/dbstore_multiinstance.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/dbstore_multiinstance.my.cnf.erb index d6a9114..ba39cb4 100644 --- a/modules/role/templates/mariadb/mysqld_config/dbstore_multiinstance.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/dbstore_multiinstance.my.cnf.erb @@ -56,6 +56,7 @@ innodb_stats_sample_pages = 16 innodb_stats_method = nulls_unequal innodb_locks_unsafe_for_binlog = 1 +innodb_file_format = barracuda # don't dump and load innodb buffer at start and stop # these servers will have the buffer pool in a bad state due to dumps diff --git a/modules/role/templates/mariadb/mysqld_config/sanitarium_multiinstance.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/sanitarium_multiinstance.my.cnf.erb index 3964154..b0aedfa 100644 --- a/modules/role/templates/mariadb/mysqld_config/sanitarium_multiinstance.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/sanitarium_multiinstance.my.cnf.erb @@ -82,6 +82,7 @@ innodb_log_file_size = 2G innodb_flush_log_at_trx_commit = 1 innodb_flush_method = O_DIRECT +innodb_file_format = barracuda join_cache_level = 8 # dump and load innodb buffer at start and stop -- To view, visit https://gerrit.wikimedia.org/r/394527 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ieff4181739e497453afcd6a96602b2ac2ad1b83c Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Marostegui <maroste...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
