I created a new table on analytics-store.eqiad.wmnet. It contains the monthly edit counts for all wikis. See a brief overview below.
Note that the "revisions" column contains a count of all revisions -- archived or not. The "archived" column contains a count of archived revisions. So revisions - archived == non-archived revisions.
analytics-store.eqiad.wmnet [staging]> explain editor_month; +-------------------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+----------------+------+-----+---------+-------+ | wiki | varbinary(50) | NO | PRI | | | | month | varbinary(7) | NO | PRI | | | | user_id | int(11) | NO | PRI | 0 | | | user_name | varbinary(191) | YES | | NULL | | | user_registration | varbinary(14) | YES | | NULL | | | archived | int(11) | YES | | NULL | | | revisions | int(11) | YES | | NULL | | +-------------------+----------------+------+-----+---------+-------+ 7 rows in set (0.01 sec)
analytics-store.eqiad.wmnet [staging]> select * from editor_month limit 3; +--------+---------+---------+------------+-------------------+----------+-----------+ | wiki | month | user_id | user_name | user_registration | archived | revisions | +--------+---------+---------+------------+-------------------+----------+-----------+ | enwiki | 2001-01 | 34 | WojPob | 20010129110725 | 0 | 13 | | enwiki | 2001-01 | 99 | RoseParks | 20010121021221 | 0 | 7 | | enwiki | 2001-01 | 479 | JimboWales | 20010123223416 | 0 | 13 | +--------+---------+---------+------------+-------------------+----------+-----------+ 3 rows in set (0.03 sec)
Feedback is welcome. One of the next things, I'd like to do is remove the "-" from the month column as it ruins comparison with MW timestamps.
-Aaron