Στις 26-09-2011, ημέρα Δευ, και ώρα 17:59 +0300, ο/η Ariel T. Glenn έγραψε:
Στις 26-09-2011, ημέρα Δευ, και ώρα 08:47 +0200, ο/η melvin_mm έγραψε:
Ariel T. Glenn<ariel<at> wikimedia.org> writes:
Στις 26-09-2011, ημέρα Δευ, και ώρα 02:20 +0200, ο/η melvin_mm έγραψε:
Ok, thanks! So in pages-meta-history, those ~33.000.000 archived / deleted revisions are not included. Probably this number consists of content from all Namespaces. What about the 37.000.000 revisions that are left now?
I guess that the wikistatistics.net page must get its values from Special:Statistics, since I see today that total number of edits as of Mon 26 Sept 2011 05:47:31 am UTC is 487,971,977, which is not far off from wikistatistics' value of 487 914 061. However, this number is not guaranteed to be accurate. The real number is
mysql> select max(rev_id) from revision; +-------------+ | max(rev_id) | +-------------+ | 452476647 | +-------------+ 1 row in set (0.00 sec)
Ariel
Thanks! Summing up: 412.482.641 counted "<revision" tags in 20110901
33.263.574 deleted revisions not included in pages-meta-history
5.391.296 revisions from September 1st to September 26th (according to wikistatistics.net, with 482.522.765 on September 1st) we get to 451.137.511 .
About 1.339.136 left from the current rev_id from the database. Where could the missing ones be? Incorrect wikistatistics.net results?
So I'd prefer not to count fromm a bunch of different times and web sites. Here's what I can tell you:
Sometime after Sept 1 16:06:24 UTC and before Sept 1 17:24:20 there were 412482641 revisions not deleted, according to the dumps.
On Sept 1 at 16:32 there were a total of 447880000 revisions, including deleted revisions.
That gives a difference of 35397359 deleted revisions (revisions no longer in the revision table). Some of those are outright deleted, and therefore among the 33000000 or so that landed in the archive table.
When a page gets restored it and all the revisions get new ids. the old ids don't point to anything any more, they are unused. I suppose that is true for undeleting selected revisions as well. That is where the missing revisions are going to be.
Clarification: this is the old behavior for revisions before mid-2005. Newer revisions keep their revision ids.
Ariel