On Fri, Sep 26, 2014 at 9:50 AM, Darko <[email protected]> wrote:
> MariaDB [hrwiki_p]> select count(*) from hrwiki_p.revision union select > count(*) from hrwiki_p.revision_userindex; > +----------+ > | count(*) | > +----------+ > | 4124635 | > | 4123974 | > > http://hr.wikipedia.org/wiki/Posebno:Statistika > > Broj uređivanja od nastanka projekta Wikipedija (Page edits since > Wikipedia was set up) > 4.558.675 > > I get that some difference comes from sanitizing data, but that should be > in range of thousands, > not hundreds of thousands. > The revision table for hrwiki on the production databases matches those numbers. "Page edits since Wikipedia was set up" counts revisions for deleted pages, which are stored in the 'archive' table. There are 244653 rows there for hrwiki, both in production and in the sanitized mirror in the Labs mirrors. -- Brad Jorsch (Anomie) Software Engineer Wikimedia Foundation
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
