Open main menu

Manual:revision_actor_temp table


Other languages:
English • ‎日本語
Manual:Contents MediaWiki database layout revision_actor_temp table


MediaWiki version: 1.31

The revision_actor_temp table is a temporary table used for the actor migration , 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 is being created to avoid such an alter, and will be merged back into the revision table in the future.

FieldsEdit

revactor_revEdit

Key to revision.rev_id.

revactor_actorEdit

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

revactor_timestampEdit

Duplicates revision.rev_timestamp, for indexing.

revactor_pageEdit

Duplicates revision.rev_page, for indexing.

Schema summaryEdit

MediaWiki version: 1.31

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           |       |
+--------------------+---------------------+------+-----+----------------+-------+

IndexesEdit

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      |         |               |
+---------------------+------------+----------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+