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 _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
