Marostegui has submitted this change and it was merged. (
https://gerrit.wikimedia.org/r/345372 )
Change subject: mysql-predump.erb: Reduce the number of jobs
......................................................................
mysql-predump.erb: Reduce the number of jobs
I am unsure if this is the correct place to reduce the concurrency of
jobs in our dbstore servers.
dbstore1001 is timming out lately because of load.
Right now it produces 12 concurrent mysqldumps, so reducing it to 8 to
see if that aliviates its load
Change-Id: If053dcb1a6c3b0d210a25a221705944c757b6227
---
M modules/backup/templates/mysql-predump.erb
1 file changed, 1 insertion(+), 1 deletion(-)
Approvals:
Marostegui: Looks good to me, approved
jenkins-bot: Verified
Jcrespo: Looks good to me, but someone else must approve
diff --git a/modules/backup/templates/mysql-predump.erb
b/modules/backup/templates/mysql-predump.erb
index a4b789a..f155349 100644
--- a/modules/backup/templates/mysql-predump.erb
+++ b/modules/backup/templates/mysql-predump.erb
@@ -51,7 +51,7 @@
find <%= @local_dump_dir %> -name "*sql.gz" -mtime +15 -exec rm {} \;
for database in `$MYSQL -B -N -e "select schema_name from
information_schema.schemata where schema_name not like '%\_schema'"`
do
- NP=$((<%= @processorcount %> * 3 / 4)) # This is guaranteed to return
an integer
+ NP=$((<%= @processorcount %> * 3 / 6)) # This is guaranteed to return
an integer
while [ $(jobs -p | wc -l) -ge $NP ]
do
sleep 1 # a magic number
--
To view, visit https://gerrit.wikimedia.org/r/345372
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: If053dcb1a6c3b0d210a25a221705944c757b6227
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui <maroste...@wikimedia.org>
Gerrit-Reviewer: Alexandros Kosiaris <akosia...@wikimedia.org>
Gerrit-Reviewer: Giuseppe Lavagetto <glavage...@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
