On 28 September 2011 16:41, Brion Vibber brion@pobox.com wrote:
On Wed, Sep 28, 2011 at 3:27 AM, K. Mueller melvin_mm@gmx.de 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