Jcrespo has submitted this change and it was merged. Change subject: Change all mysql servers to max_allowed_package = 32MB ......................................................................
Change all mysql servers to max_allowed_package = 32MB While 32MB queries are undesirable, when using mysqldump is is possible to run out of query size for batch insert. Additionally, many servers are requiring now larger configuration variables, like OTRS and Phabricator, and once we have changed one server, we risk having the problem when being imported on another one- so lets agree on a single commit to change it overally. Change-Id: I66320daa5b9104ad6f96a1c606037502d4e10bc0 --- M templates/mariadb/analytics.my.cnf.erb M templates/mariadb/beta.my.cnf.erb M templates/mariadb/dbstore.my.cnf.erb M templates/mariadb/eventlogging.my.cnf.erb M templates/mariadb/labs.my.cnf.erb M templates/mariadb/phabricator.my.cnf.erb M templates/mariadb/production.my.cnf.erb M templates/mariadb/tendril.my.cnf.erb M templates/mariadb/tools.my.cnf.erb M templates/mariadb/wikitech.my.cnf.erb 10 files changed, 24 insertions(+), 24 deletions(-) Approvals: Jcrespo: Looks good to me, approved jenkins-bot: Verified diff --git a/templates/mariadb/analytics.my.cnf.erb b/templates/mariadb/analytics.my.cnf.erb index e984cf0..a348452 100644 --- a/templates/mariadb/analytics.my.cnf.erb +++ b/templates/mariadb/analytics.my.cnf.erb @@ -21,7 +21,7 @@ read_only = 0 max_connections = 256 -max_allowed_packet = 16M +max_allowed_packet = 32M connect_timeout = 3 query_cache_size = 0 query_cache_type = 0 @@ -66,6 +66,6 @@ [mysqldump] quick -max_allowed_packet = 16M +max_allowed_packet = 32M -#!includedir /etc/mysql/conf.d/ \ No newline at end of file +#!includedir /etc/mysql/conf.d/ diff --git a/templates/mariadb/beta.my.cnf.erb b/templates/mariadb/beta.my.cnf.erb index c67fd55..7e49ccd 100644 --- a/templates/mariadb/beta.my.cnf.erb +++ b/templates/mariadb/beta.my.cnf.erb @@ -23,7 +23,7 @@ read_only = 0 max_connections = 250 -max_allowed_packet = 16M +max_allowed_packet = 32M sync_binlog = 1 binlog_format = statement expire_logs_days = 30 @@ -39,6 +39,6 @@ [mysqldump] quick -max_allowed_packet = 16M +max_allowed_packet = 32M -#!includedir /etc/mysql/conf.d/ \ No newline at end of file +#!includedir /etc/mysql/conf.d/ diff --git a/templates/mariadb/dbstore.my.cnf.erb b/templates/mariadb/dbstore.my.cnf.erb index c2ed806..b728246 100644 --- a/templates/mariadb/dbstore.my.cnf.erb +++ b/templates/mariadb/dbstore.my.cnf.erb @@ -22,7 +22,7 @@ read_only = 0 max_connections = 250 -max_allowed_packet = 16M +max_allowed_packet = 32M connect_timeout = 3 query_cache_size = 0 query_cache_type = 0 @@ -83,6 +83,6 @@ [mysqldump] quick -max_allowed_packet = 16M +max_allowed_packet = 32M #!includedir /etc/mysql/conf.d/ diff --git a/templates/mariadb/eventlogging.my.cnf.erb b/templates/mariadb/eventlogging.my.cnf.erb index 1356564..a10eb8f 100644 --- a/templates/mariadb/eventlogging.my.cnf.erb +++ b/templates/mariadb/eventlogging.my.cnf.erb @@ -25,7 +25,7 @@ max_connections = 500 extra_max_connections = 10 max_connect_errors = 1000000000 -max_allowed_packet = 16M +max_allowed_packet = 32M connect_timeout = 10 query_cache_size = 0 query_cache_type = 0 @@ -74,6 +74,6 @@ [mysqldump] quick -max_allowed_packet = 16M +max_allowed_packet = 32M -#!includedir /etc/mysql/conf.d/ \ No newline at end of file +#!includedir /etc/mysql/conf.d/ diff --git a/templates/mariadb/labs.my.cnf.erb b/templates/mariadb/labs.my.cnf.erb index 453141c..0357c71 100644 --- a/templates/mariadb/labs.my.cnf.erb +++ b/templates/mariadb/labs.my.cnf.erb @@ -21,7 +21,7 @@ max_connections = 1000 max_connect_errors = 1000000000 -max_allowed_packet = 16M +max_allowed_packet = 32M connect_timeout = 3 query_cache_size = 0 query_cache_type = 0 @@ -106,6 +106,6 @@ [mysqldump] quick -max_allowed_packet = 16M +max_allowed_packet = 32M #!includedir /etc/mysql/conf.d/ diff --git a/templates/mariadb/phabricator.my.cnf.erb b/templates/mariadb/phabricator.my.cnf.erb index 49ccfd7..00203f0 100644 --- a/templates/mariadb/phabricator.my.cnf.erb +++ b/templates/mariadb/phabricator.my.cnf.erb @@ -76,6 +76,6 @@ [mysqldump] quick -max_allowed_packet = 16M +max_allowed_packet = 32M #!includedir /etc/mysql/conf.d/ diff --git a/templates/mariadb/production.my.cnf.erb b/templates/mariadb/production.my.cnf.erb index 2eb66ce..298c739 100644 --- a/templates/mariadb/production.my.cnf.erb +++ b/templates/mariadb/production.my.cnf.erb @@ -32,7 +32,7 @@ back_log = 500 extra_max_connections = 10 max_connect_errors = 1000000000 -max_allowed_packet = 16M +max_allowed_packet = 32M connect_timeout = 3 query_cache_size = 0 query_cache_type = 0 @@ -117,6 +117,6 @@ [mysqldump] quick -max_allowed_packet = 16M +max_allowed_packet = 32M #!includedir /etc/mysql/conf.d/ diff --git a/templates/mariadb/tendril.my.cnf.erb b/templates/mariadb/tendril.my.cnf.erb index 3708e7c..98d36e2 100644 --- a/templates/mariadb/tendril.my.cnf.erb +++ b/templates/mariadb/tendril.my.cnf.erb @@ -21,7 +21,7 @@ read_only = 0 max_connections = 250 -max_allowed_packet = 16M +max_allowed_packet = 32M connect_timeout = 3 max_connect_errors = 1000000000 query_cache_size = 0 @@ -49,6 +49,6 @@ [mysqldump] quick -max_allowed_packet = 16M +max_allowed_packet = 32M -#!includedir /etc/mysql/conf.d/ \ No newline at end of file +#!includedir /etc/mysql/conf.d/ diff --git a/templates/mariadb/tools.my.cnf.erb b/templates/mariadb/tools.my.cnf.erb index 5886a2b..740647d 100644 --- a/templates/mariadb/tools.my.cnf.erb +++ b/templates/mariadb/tools.my.cnf.erb @@ -22,7 +22,7 @@ max_connections = 1024 max_connect_errors = 1000000000 -max_allowed_packet = 16M +max_allowed_packet = 32M connect_timeout = 5 query_cache_size = 0 query_cache_type = 0 @@ -64,6 +64,6 @@ [mysqldump] quick -max_allowed_packet = 16M +max_allowed_packet = 32M #!includedir /etc/mysql/conf.d/ diff --git a/templates/mariadb/wikitech.my.cnf.erb b/templates/mariadb/wikitech.my.cnf.erb index 6a34c9e..b9a13a4 100644 --- a/templates/mariadb/wikitech.my.cnf.erb +++ b/templates/mariadb/wikitech.my.cnf.erb @@ -25,7 +25,7 @@ max_connections = 250 extra_max_connections = 10 max_connect_errors = 1000000000 -max_allowed_packet = 16M +max_allowed_packet = 32M connect_timeout = 3 query_cache_size = 0 query_cache_type = 0 @@ -62,6 +62,6 @@ [mysqldump] quick -max_allowed_packet = 16M +max_allowed_packet = 32M -#!includedir /etc/mysql/conf.d/ \ No newline at end of file +#!includedir /etc/mysql/conf.d/ -- To view, visit https://gerrit.wikimedia.org/r/249135 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I66320daa5b9104ad6f96a1c606037502d4e10bc0 Gerrit-PatchSet: 3 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Jcrespo <[email protected]> Gerrit-Reviewer: Alexandros Kosiaris <[email protected]> Gerrit-Reviewer: Jcrespo <[email protected]> Gerrit-Reviewer: Ottomata <[email protected]> Gerrit-Reviewer: coren <[email protected]> Gerrit-Reviewer: jenkins-bot <> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
