On Wed, Sep 28, 2011 at 3:27 AM, K. Mueller
<melvin_mm(a)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