Jcrespo has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/358918 )
Change subject: mariadb: Enable file-per-table option on parsercaches ...................................................................... mariadb: Enable file-per-table option on parsercaches This should be ok- we only have 255 tables, modern mariadb/mysql handle those well, and othewise it is not easy to purge OS file space. This made sense in 5.5 an below, but it should be ok now. Existing databases are not in danger of duplicating its disk space usage because it requires a manual rebuilt to apply it. Bug: T167567 Change-Id: Ifc653c8b2eef36ff54fdb761ffa281fb80c6787f --- M modules/role/templates/mariadb/mysqld_config/parsercache.my.cnf.erb 1 file changed, 2 insertions(+), 2 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/18/358918/1 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 374c4d1..cf4bbb4 100644 --- a/modules/role/templates/mariadb/mysqld_config/parsercache.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/parsercache.my.cnf.erb @@ -88,8 +88,8 @@ collation_server = binary default-storage-engine = InnoDB -# disable file-per-table to avoid multiple small objects -innodb_file_per_table = 0 +# enable innodb_file_per_table to allow size purging +innodb_file_per_table = 1 innodb_buffer_pool_size = <%= (Float(@memorysize.split[0]) * 0.75).round %>G innodb_log_file_size = 2G # reduce durability - this is a cache server -- To view, visit https://gerrit.wikimedia.org/r/358918 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ifc653c8b2eef36ff54fdb761ffa281fb80c6787f Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Jcrespo <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
