https://bugzilla.wikimedia.org/show_bug.cgi?id=45584
Web browser: ---
Bug ID: 45584
Summary: WikiExporter is causing replication issues
Product: MediaWiki
Version: 1.21-git
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: Unprioritized
Component: Export/Import
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Classification: Unclassified
Mobile Platform: ---
WikiExporter (as called via the dump code on snapshot2) is selecting the entire
revision table joined with page in a single query:
SELECT /* WikiExporter::dumpFrom 127.0.0.1 */ /*! STRAIGHT_JOIN */ * FROM
`page` FORCE INDEX (PRIMARY) INNER JOIN `revision` ON ((page_id=rev_page))
ORDER BY page_id ASC
This results in very long running transactions that have been impacting
replication.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
