https://bugzilla.wikimedia.org/show_bug.cgi?id=41668
Web browser: ---
Bug #: 41668
Summary: WikiExporter does not respect
groupLoadsByDB[$wiki]['dump']
Product: MediaWiki
Version: 1.21-git
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Maintenance scripts
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
Mobile Platform: ---
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.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
