[Labs-l] Too big difference

Fri Sep 26 14:15:44 UTC 2014

The user index table does not include anon edits

On Friday, September 26, 2014, Darko <darko.wikipedija at gmail.com> wrote:

> Hello,
>
> 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.
>
> Any insight, rep lag in range of months?
>
>
> --
> TIA
>
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20140926/541f8d43/attachment.html>