Author: afeldman
Description:
I was just investigating some performance issues on one of the main enwiki slaves (db60) and see several > hour long dump queries running from storage4:
9526634472 | wikiadmin | 10.0.10.4:35311 | enwiki | Query | 3801 | Writing to net | SELECT /* WikiExporter::dumpFrom */ * FROM page INNER JOIN revision ON ((page_id=rev_page)) WHERE page_id >= 465001 AND page_id < 665001 ORDER BY page_id ASC |
db.php contains:
'groupLoadsByDB' => array(
'enwiki' => array( 'watchlist' => array( 'db36' => 1, ), 'recentchangeslinked' => array( 'db36' => 1, ), 'contributions' => array( 'db36' => 1, ), 'dump' => array( 'db36' => 1, ),
)
Which was intended to direct all enwiki dump queries to db36, but it looks like this is no longer respected. Please fix.
Version: 1.21.x
Severity: normal