Marostegui has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/394542 )
Change subject: mariadb: Enable barracuda in some more hosts ...................................................................... mariadb: Enable barracuda in some more hosts Bug: T150949 Change-Id: Ib12858e27e4f874ebc0d68785e7338c165856206 --- M modules/role/templates/mariadb/mysqld_config/dbstore.my.cnf.erb M modules/role/templates/mariadb/mysqld_config/labsdb-replica.my.cnf.erb M modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb M modules/role/templates/mariadb/mysqld_config/tendril.my.cnf.erb 4 files changed, 4 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/42/394542/1 diff --git a/modules/role/templates/mariadb/mysqld_config/dbstore.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/dbstore.my.cnf.erb index b5c3622..dff46bb 100644 --- a/modules/role/templates/mariadb/mysqld_config/dbstore.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/dbstore.my.cnf.erb @@ -68,6 +68,7 @@ innodb_stats_sample_pages = 16 innodb_stats_method = nulls_unequal innodb_locks_unsafe_for_binlog = 1 +innodb_file_format = barracuda aria_pagecache_buffer_size = 16G # dump and load innodb buffer at start and stop diff --git a/modules/role/templates/mariadb/mysqld_config/labsdb-replica.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/labsdb-replica.my.cnf.erb index 0085d5e..c243ba3 100644 --- a/modules/role/templates/mariadb/mysqld_config/labsdb-replica.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/labsdb-replica.my.cnf.erb @@ -83,6 +83,7 @@ innodb_io_capacity = 1000 innodb_stats_sample_pages = 16 innodb_stats_method = nulls_unequal +innodb_file_format = barracuda <% if @kernelversion < "3.19" %> # Until kernel 3.16 http://www.spinics.net/lists/stable/msg61873.html diff --git a/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb index 93c9b19..dfd6879 100644 --- a/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb @@ -135,6 +135,7 @@ innodb_io_capacity = 1000 innodb_stats_sample_pages = 16 innodb_stats_method = nulls_unequal +innodb_file_format = barracuda aria_pagecache_buffer_size = 1G join_cache_level = 8 diff --git a/modules/role/templates/mariadb/mysqld_config/tendril.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/tendril.my.cnf.erb index 1baf8e0..6fe81d6 100644 --- a/modules/role/templates/mariadb/mysqld_config/tendril.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/tendril.my.cnf.erb @@ -68,6 +68,7 @@ innodb_log_file_size = 1G innodb_flush_log_at_trx_commit = 0 innodb_flush_method = O_DIRECT +innodb_file_format = barracuda aria_pagecache_buffer_size = 1G tokudb_cache_size = 24G -- To view, visit https://gerrit.wikimedia.org/r/394542 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ib12858e27e4f874ebc0d68785e7338c165856206 Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Marostegui <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
