Marostegui has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/394994 )
Change subject: mariadb: Enable barracuda on the last roles ...................................................................... mariadb: Enable barracuda on the last roles Bug: T150949 Change-Id: Ibf94389bcf492c50771732b4342fcf1a4c5e171e --- M modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb M modules/role/templates/mariadb/mysqld_config/parsercache.my.cnf.erb M modules/role/templates/mariadb/mysqld_config/phabricator.my.cnf.erb M modules/role/templates/mariadb/mysqld_config/wikitech.my.cnf.erb 4 files changed, 4 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/94/394994/1 diff --git a/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb index 6a74eb2..c187937 100644 --- a/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb @@ -81,6 +81,7 @@ innodb_stats_sample_pages = 16 innodb_stats_method = nulls_unequal innodb_locks_unsafe_for_binlog = 1 +innodb_file_format = barracuda tokudb_data_dir = /srv/tokudb tokudb_cache_size = <%= (Float(@memorysize.split[0]) * 0.50).round %>G tokudb_lock_timeout = 50000 diff --git a/modules/role/templates/mariadb/mysqld_config/parsercache.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/parsercache.my.cnf.erb index 98c0b34..7cbcecf 100644 --- a/modules/role/templates/mariadb/mysqld_config/parsercache.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/parsercache.my.cnf.erb @@ -100,6 +100,7 @@ innodb_io_capacity = 20000 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/phabricator.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/phabricator.my.cnf.erb index cc00ab7..fde51e6 100644 --- a/modules/role/templates/mariadb/mysqld_config/phabricator.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/phabricator.my.cnf.erb @@ -96,6 +96,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/wikitech.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/wikitech.my.cnf.erb index 7da77a4..3750e13 100644 --- a/modules/role/templates/mariadb/mysqld_config/wikitech.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/wikitech.my.cnf.erb @@ -64,6 +64,7 @@ innodb_flush_log_at_trx_commit = 1 innodb_flush_method = O_DIRECT innodb_thread_concurrency = 0 +innodb_file_format = barracuda aria_pagecache_buffer_size = 128M [mysqldump] -- To view, visit https://gerrit.wikimedia.org/r/394994 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ibf94389bcf492c50771732b4342fcf1a4c5e171e 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
