Στις 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 _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l