maintenance/purgeStaleMemcachedText.php

   1 <?php
   2
   3 require_once( dirname( __FILE__ ) . '/commandLine.inc' );
   4
   5 function purgeStaleMemcachedText() {
   6         global $wgMemc;
   7         $db = wfGetDB( DB_MASTER );
   8         $maxTextId = $db->selectField( 'text', 'max(old_id)' );
   9         $latestReplicatedTextId = $db->selectField( array( 'revision','recentchanges'), 'rev_text_id', array( 'rev_id = rc_this_oldid', "rc_timestamp < '201012250630'" ) );
  10         $latestReplicatedTextId -= 100; # A bit of paranoia
  11
  12         for ( $i = $latestReplicatedTextId; $i < $maxTextId; $i++ ) {
  13                 $key = wfMemcKey( 'revisiontext', 'textid', $i++ );
  14                 $wgMemc->delete( $key );
  15         }
  16 }
  17
  18 purgeStaleMemcachedText();
  19