John <phoenixoverride <at> gmail.com> writes:
mysql> select count(*) from archive; +----------+ | count(*) | +----------+ | 33263574 | +----------+ 1 row in set (8 min 47.50 sec)
On Sun, Sep 25, 2011 at 5:13 PM, melvin_mm <melvin_mm <at> gmx.de> wrote:
Bryan Tong Minh <bryan.tongminh <at> gmail.com> writes:
Deleted revisions?
If deleted revisions sum up to ~70.000.000 - could I add this information to http://en.wikipedia.org/wiki/Wikipedia:Database_download ?
What would you advice to do if I wanted to verify the counter result?
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?
Στις 26-09-2011, ημέρα Δευ, και ώρα 02:20 +0200, ο/η melvin_mm έγραψε:
John <phoenixoverride <at> gmail.com> writes:
mysql> select count(*) from archive; +----------+ | count(*) | +----------+ | 33263574 | +----------+ 1 row in set (8 min 47.50 sec)
On Sun, Sep 25, 2011 at 5:13 PM, melvin_mm <melvin_mm <at> gmx.de> wrote:
Bryan Tong Minh <bryan.tongminh <at> gmail.com> writes:
Deleted revisions?
If deleted revisions sum up to ~70.000.000 - could I add this information to http://en.wikipedia.org/wiki/Wikipedia:Database_download ?
What would you advice to do if I wanted to verify the counter result?
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
wikitech-l@lists.wikimedia.org