From 89b49c49c1884b0894633448c314d6beccad3e3d Mon Sep 17 00:00:00 2001 From: Roan Kattouw Date: Wed, 27 Oct 2010 18:49:18 +0000 Subject: [PATCH] Revert unintended changes in r75555 --- maintenance/cleanupRemovedModules.php | 83 --------------------------- 1 file changed, 83 deletions(-) delete mode 100644 maintenance/cleanupRemovedModules.php diff --git a/maintenance/cleanupRemovedModules.php b/maintenance/cleanupRemovedModules.php deleted file mode 100644 index 9f22adf55c..0000000000 --- a/maintenance/cleanupRemovedModules.php +++ /dev/null @@ -1,83 +0,0 @@ - - */ - -require_once( dirname( __FILE__ ) . '/Maintenance.php' ); - -class CleanupRemovedModules extends Maintenance { - - public function __construct() { - parent::__construct(); - $this->mDescription = 'Remove cache entries for removed ResourceLoader modules from the database'; - $this->addOption( 'batchsize', 'Delete rows in batches of this size. Default: 500', false, true ); - $this->addOption( 'max-slave-lag', 'If the slave lag exceeds this many seconds, wait until it drops below this value. Default: 5', false, true ); - } - - public function execute() { - $dbw = wfGetDB( DB_MASTER ); - $rl = new ResourceLoader(); - $moduleNames = array_keys( $rl->getModules() ); - $moduleList = implode( ', ', array_map( array( $dbw, 'addQuotes' ), $moduleNames ) ); - $limit = min( 1, intval( $this->getOption( 'batchsize', 500 ) ) ); - $maxlag = intval( $this->getOption( 'max-slave-lag', 5 ) ); - - $this->output( "Cleaning up module_deps table...\n" ); - $i = 1; - do { - // $dbw->delete() doesn't support LIMIT :( - $dbw->query( "DELETE FROM module_deps WHERE md_module NOT IN ($moduleList) LIMIT $limit", __METHOD__ ); - $numRows = $dbw->affectedRows(); - $this->output( "Batch $i: $numRows rows\n" ); - $i++; - wfWaitForSlaves( $maxlag ); - } while( $dbw->affectedRows() > 0 ); - $this->output( "done\n" ); - - $this->output( "Cleaning up msg_resource table...\n" ); - $i = 1; - do { - // $dbw->delete() doesn't support LIMIT :( - $dbw->query( "DELETE FROM msg_resource WHERE mr_resource NOT IN ($moduleList) LIMIT $limit", __METHOD__ ); - $numRows = $dbw->affectedRows(); - $this->output( "Batch $i: $numRows rows\n" ); - $i++; - wfWaitForSlaves( $maxlag ); - } while( $dbw->affectedRows() > 0 ); - $this->output( "done\n" ); - - $this->output( "Cleaning up msg_resource_links table...\n" ); - $i = 1; - do { - // $dbw->delete() doesn't support LIMIT :( - $dbw->query( "DELETE FROM msg_resource_links WHERE mrl_resource NOT IN ($moduleList) LIMIT $limit", __METHOD__ ); - $numRows = $dbw->affectedRows(); - $this->output( "Batch $i: $numRows rows\n" ); - $i++; - wfWaitForSlaves( $maxlag ); - } while( $dbw->affectedRows() > 0 ); - $this->output( "done\n" ); - } -} - -$maintClass = "CleanupRemovedModules"; -require_once( DO_MAINTENANCE ); \ No newline at end of file -- 2.20.1