Marostegui has submitted this change and it was merged. ( https://gerrit.wikimedia.org/r/391517 )
Change subject: tools.my.cnf.erb: Ignore memory tables for s51290 ...................................................................... tools.my.cnf.erb: Ignore memory tables for s51290 The user s51290__dpl_p keeps creating new memory tables with the prefix "i_" and "u_" and they keep getting full, and being recreated, so there is no way to avoid breaking replication but ignoring them on replication. Bug: T180560 Change-Id: I9464f32e33e87515ee8aee13ecafa5264387d5fd --- M modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb 1 file changed, 2 insertions(+), 4 deletions(-) Approvals: Marostegui: Looks good to me, approved jenkins-bot: Verified diff --git a/modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb index c3f4e87..70fb890 100644 --- a/modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb @@ -67,10 +67,8 @@ replicate_wild_ignore_table = s51071\_\_templatetiger\_p.% replicate_wild_ignore_table = s52721\_\_pagecount\_stats\_p.% # T180560 -replicate_wild_ignore_table = s51290__dpl_p.i_orphan_candidates -replicate_wild_ignore_table = s51290__dpl_p.i_psub -replicate_wild_ignore_table = s51290__dpl_p.i_redirects -replicate_wild_ignore_table = s51290__dpl_p.u_pagelinks +replicate_wild_ignore_table = s51290__dpl_p.u\_% +replicate_wild_ignore_table = s51290__dpl_p.i\_% table_open_cache = 5000 table_definition_cache = 4000 -- To view, visit https://gerrit.wikimedia.org/r/391517 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I9464f32e33e87515ee8aee13ecafa5264387d5fd Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Marostegui <maroste...@wikimedia.org> Gerrit-Reviewer: Jcrespo <jcre...@wikimedia.org> Gerrit-Reviewer: Marostegui <maroste...@wikimedia.org> Gerrit-Reviewer: jenkins-bot <> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits