On 28 September 2011 16:41, Brion Vibber <[email protected]> wrote: > On Wed, Sep 28, 2011 at 3:27 AM, K. Mueller <[email protected]> wrote: > > > Platonides <Platonides <at> gmail.com> writes: > > > Do doing things the slow way: > > > mysql> SELECT COUNT(*) FROM revision; > > > | 416988781 | > > > > Thanks, this is quite close to the result from September 1st ( > 412,482,641 > > ). I > > assume that the contents of the "revision" table go into the > > pages-meta-history > > dumps..? And I reckon that there is no safe method to verify the result, > > though. > > > > The pages-meta-history dump (with text) is produced from the > pages-meta-history _stub_ dump, which is basically just a thin XML shell > around a big query to the database on the 'page' and 'revision' tables. > > In theory, anything missing from the stub dump should be something that's > not properly recorded at all -- for instance a revision that is not > attached > to a live page. This isn't supposed to happen but there probably are a few > stray ones in the database. :) > > -- brion >
SELECT * FROM `revision` LEFT JOIN `page` ON `rev_page` = `page_id` WHERE `page_id` IS NULL Anyone want a sweepstake on how long that'll take? 8-) --HM _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
