Jcrespo has submitted this change and it was merged. ( 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(-) Approvals: Marostegui: Looks good to me, but someone else must approve jenkins-bot: Verified Jcrespo: Looks good to me, approved 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: merged Gerrit-Change-Id: Ifc653c8b2eef36ff54fdb761ffa281fb80c6787f Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Jcrespo <[email protected]> Gerrit-Reviewer: Giuseppe Lavagetto <[email protected]> Gerrit-Reviewer: Jcrespo <[email protected]> Gerrit-Reviewer: Marostegui <[email protected]> Gerrit-Reviewer: jenkins-bot <> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
