https://bugzilla.wikimedia.org/show_bug.cgi?id=27112
--- Comment #5 from Ariel T. Glenn ar...@wikimedia.org ---
It's possible to request a dump by arbitrary page range (and in fact that
feature is used), so no, we can't guarantee that the range will be small,
unfortunately.
We really only need
https://bugzilla.wikimedia.org/show_bug.cgi?id=27112
--- Comment #2 from Ariel T. Glenn ar...@wikimedia.org ---
So does anyone on this bug have any objections if I explicitly ORDER BY rev_id
ASC at the end of that query? Is that going to kill performance or break some
subtle thing in the dumps as
https://bugzilla.wikimedia.org/show_bug.cgi?id=27112
--- Comment #3 from Ariel T. Glenn ar...@wikimedia.org ---
the explain doesn't look good, yuck:
explain SELECT * FROM `page` INNER JOIN `revision` ON ((page_id=rev_page))
WHERE page_id = 1157 AND page_id 1158 ORDER BY page_id ASC,
https://bugzilla.wikimedia.org/show_bug.cgi?id=27112
Sean Pringle sprin...@wikimedia.org changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=27112
Diederik van Liere dvanli...@gmail.com changed:
What|Removed |Added
Keywords||analytics
https://bugzilla.wikimedia.org/show_bug.cgi?id=27112
--- Comment #1 from Brion Vibber br...@pobox.com 2011-02-02 19:28:14 UTC ---
Note that mismatched ordering might really confuse the dump prefetching code,
which IIRC assumes a consistent order of (page_id, rev_id).
There are many perfectly
https://bugzilla.wikimedia.org/show_bug.cgi?id=27112
Ariel T. Glenn ar...@wikimedia.org changed:
What|Removed |Added
Severity|enhancement |minor
--