Hi all!
Apparently, we are approaching 20 Million pages worldwide (by some count. I have no idea what that actually includes). Does anyone here know of a nice counter/countdown tool we could use to show this off? Like the nice counter we had für the billionth edit last year, perhaps.
I'm aware that this number can never be accurate, and there are several valid definitions of "page", etc. I'm just looking for something that is "close enough" to show off.
Does this exist? Or would anyone like to write it?
Cheers Daniel
PS: please CC catrin in your replies, she isn't on this list
Hello Daniel.
On 9 September 2011 14:32, Daniel Kinzler daniel@brightbyte.de wrote:
Apparently, we are approaching 20 Million pages worldwide (by some count. I have no idea what that actually includes).
(...)
I'm aware that this number can never be accurate, and there are several valid definitions of "page", etc. I'm just looking for something that is "close enough" to show off.
I think the 20 million is based on Special:Statistics[1], which shows 'Content pages' (currently 3.7M on enwiki). This is the 'ss_good_articles' column in the site_stats table:
mysql> select ss_good_articles from site_stats; +------------------+ | ss_good_articles | +------------------+ | 3733749 | +------------------+ 1 row in set (0.00 sec)
It might actually be interesting to solve this in a more global way: a site_stats toolserver table that incorporates all site_stats values for all wikis.
Of course, for the nice counter, you could want some more data, such as the increase per unit of time, so you could use javascript to 'automatically' update the counter.
Best, Merlijn
Hi Daniel & Catrin,
As a followup..
On 9 September 2011 15:12, Merlijn van Deen valhallasw@arctus.nl wrote:
It might actually be interesting to solve this in a more global way: a site_stats toolserver table that incorporates all site_stats values for all wikis.
I did exactly this: see u_valhallasw_p.site_stats_global on sql-s1. However, there is a slight issue here:
I think the 20 million is based on Special:Statistics[1], which shows 'Content pages' (currently 3.7M on enwiki). This is the 'ss_good_articles' column in the site_stats table:
mysql> select sum(ss_good_articles) from toolserver.wiki as w left join u_valhallasw_p.site_stats_global as s on w.dbname=s.dbname where w.is_meta=0 and is_closed=0 group by is_closed; +-----------------------+ | sum(ss_good_articles) | +-----------------------+ | 50899768 | +-----------------------+ 1 row in set (0.48 sec)
So. 50 million, not 20 million. Even if we just take wikipedia into account...
mysql> select sum(ss_good_articles) from toolserver.wiki as w left join u_valhallasw_p.site_stats_global as s on w.dbname=s.dbname where w.is_meta=0 and is_closed=0 and family='wikipedia' group by is_closed; +-----------------------+ | sum(ss_good_articles) | +-----------------------+ | 33785183 | +-----------------------+ 1 row in set (0.14 sec)
Again, much more than 20 million... anyway, feel free to play with the site_stats_global table to get the numbers you need; it's not updated automatically. It takes about 5 seconds to update, so it could be updated quite regularly.
Best, Merlijn
P.S. Some more global stats: 3,021,285,140 edits on all non-meta wikimedia wikis 2,478,927,229 edits on all non-meta open wikipedias 142,927,813 pages on wikipedia 271,005,298 pages on all non-meta wikis
toolserver-l@lists.wikimedia.org