Manual:revision_actor_temp table

Manual:Contents MediaWiki database layout revision_actor_temp table
MediaWiki versions:
1.31 – 1.38

The revision_actor_temp table was a temporary table used for the Actor migration (alongside with revision_comment_temp ), creating a relation between each row of the revision table and a row of the actor table. On large wikis like English Wikipedia, altering the revision table is a months-long process. This table was created so that other data migrations could be done while the alter was running. Once adding the rev_actor field to the revision table was done, the data from revision_actor_temp was merged back into the revision table and the table was deleted.

Fields

edit

revactor_rev

edit

Key to revision.rev_id.

revactor_actor

edit

Key to actor.actor_id. Replaces revision.rev_user and revision.rev_user_text, will eventually be replaced by revision.rev_actor.

revactor_timestamp

edit

Duplicates revision.rev_timestamp, for indexing.

revactor_page

edit

Duplicates revision.rev_page, for indexing.

Schema summary

edit
MediaWiki versions:
1.36 – 1.38

DESCRIBE revision_actor_temp;

+--------------------+---------------------+------+-----+----------------+-------+
| Field              | Type                | Null | Key | Default        | Extra |
+--------------------+---------------------+------+-----+----------------+-------+
| revactor_rev       | int(10) unsigned    | NO   | PRI | NULL           |       |
| revactor_actor     | bigint(20) unsigned | NO   | PRI | NULL           |       |
| revactor_timestamp | binary(14)          | NO   |     | NULL           |       |
| revactor_page      | int(10) unsigned    | NO   | MUL | NULL           |       |
+--------------------+---------------------+------+-----+----------------+-------+
MediaWiki versions:
1.31 – 1.35

DESCRIBE revision_actor_temp;

+--------------------+---------------------+------+-----+----------------+-------+
| Field              | Type                | Null | Key | Default        | Extra |
+--------------------+---------------------+------+-----+----------------+-------+
| revactor_rev       | int(10) unsigned    | NO   | PRI | NULL           |       |
| revactor_actor     | bigint(20) unsigned | NO   | PRI | NULL           |       |
| revactor_timestamp | binary(14)          | NO   |     |                |       |
| revactor_page      | int(10) unsigned    | NO   | MUL | NULL           |       |
+--------------------+---------------------+------+-----+----------------+-------+

Indexes

edit
MediaWiki versions:
1.31 – 1.38

SHOW INDEX IN revision_actor_temp;

+---------------------+------------+----------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table               | Non_unique | Key_name             | Seq_in_index | Column_name        | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------------+------------+----------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| revision_actor_temp |          0 | PRIMARY              |            1 | revactor_rev       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| revision_actor_temp |          0 | PRIMARY              |            2 | revactor_actor     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| revision_actor_temp |          0 | revactor_rev         |            1 | revactor_rev       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| revision_actor_temp |          1 | actor_timestamp      |            1 | revactor_actor     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| revision_actor_temp |          1 | actor_timestamp      |            2 | revactor_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| revision_actor_temp |          1 | page_actor_timestamp |            1 | revactor_page      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| revision_actor_temp |          1 | page_actor_timestamp |            2 | revactor_actor     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| revision_actor_temp |          1 | page_actor_timestamp |            3 | revactor_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+---------------------+------------+----------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+