Page MenuHomePhabricator

UserMerge: don't update the entire table in one query
Closed, ResolvedPublic

Description

Needs batching...


Version: unspecified
Severity: normal

Details

Reference
bz70376

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 3:46 AM
bzimport set Reference to bz70376.
Legoktm created this task.Sep 4 2014, 1:09 AM
Reedy added a comment.Sep 4 2014, 1:12 AM

From the runBatchedQuery.php maintenance script:

		do {
			$this->output( "Batch $n: " );
			$n++;
			$dbw->query( $query, __METHOD__ );
			$affected = $dbw->affectedRows();
			$this->output( "$affected rows\n" );
			wfWaitForSlaves();
		} while ( $affected > 0 );

This should be easily enough modified to do it...

gerritadmin wrote:

Change 158310 had a related patch set uploaded by Reedy:
Don't update the entire table in one query

https://gerrit.wikimedia.org/r/158310

gerritadmin wrote:

Change 158310 merged by jenkins-bot:
Don't update the entire table in one query to avoid melting servers

https://gerrit.wikimedia.org/r/158310