Fæ wrote:
Re:
https://meta.wikimedia.org/wiki/User:Faebot/thanks
I am glad the tables are useful, hopefully stimulating more positive
use of the thanks notifier by contributors.
The reports are updating *slowly*, currently at April 2014... This is
in part because of the WMFlabs outage yesterday, though in general any
report of the "logging" table is going to be slow (it is the largest
table on the wiki database). The first run-through will take several
days as it is going back through all of 2014. Once it is only
reporting on the previous month, I suspect it will finish monthly
updates within the first first day.
Hi.
Hmm, I'm not sure how you're measuring largest, but I imagine on most
wikis there are more rows in the revision table than there are in the
logging table. For example, on the English Wikipedia, there are
approximately 598,859,006 rows in the revision table and 62,731,285 rows
in the logging table. I suspect on most wikis, revision, text, and maybe
archive would typically be larger than logging, except in weird cases
such as loginwiki[_p]. And then of course there are the *links tables. But
it depends on whether you're comparing size on disk or number of rows.
You probably want to use logging_userindex instead of logging. The former
is typically significantly faster due to the way we use table views.
I have a bit of experience with database reports. Off-hand I'd say it
should be possible to query all of this information in under an hour. With
the index on logging[_userindex].log_action, even a large table such as
logging shouldn't be too awful to query for this information. If you have
queries that are taking a very long time, we should probably investigate.
MZMcBride