Last modified: 2013-01-14 21:45:10 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T43668, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 41668 - WikiExporter does not respect groupLoadsByDB[$wiki]['dump']
WikiExporter does not respect groupLoadsByDB[$wiki]['dump']
Status: NEW
Product: MediaWiki
Classification: Unclassified
Maintenance scripts (Other open bugs)
1.21.x
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2012-11-01 23:57 UTC by Asher Feldman
Modified: 2013-01-14 21:45 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Asher Feldman 2012-11-01 23:57:11 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links