Handbuch:revision_comment_temp-Tabelle

↑ Handbuch:Inhaltsübersicht

MediaWiki-Datenbank-Layout

revision_comment_temp-Tabelle

MediaWiki Versions:

1.30 – 1.40

The revision_comment_temp table was a temporary table creating a relation between each row of the revision table and a row of the comment table. It was created (along with the similar revision_actor_temp table) to avoid blocking on an alter of the revision table, which took . On large wikis like the 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_comment_id field to the revision table was done, the data from revision_comment_temp was merged back into the revision table and the table was deleted.

Diese Tabelle wurde in Gerrit change 357892 eingeführt. Siehe auch die image_comment_temp -Tabelle.

Felder

revcomment_rev

Schlüssel zu revision.rev_id

revcomment_comment_id

Schlüssel zu comment.comment_id

Schematische Übersicht

MediaWiki Versions:

1.30 – 1.40

DESCRIBE revision_comment_temp;

+-----------------------+---------------------+------+-----+---------+-------+
| Field                 | Type                | Null | Key | Default | Extra |
+-----------------------+---------------------+------+-----+---------+-------+
| revcomment_rev        | int(10) unsigned    | NO   | PRI | NULL    |       |
| revcomment_comment_id | bigint(20) unsigned | NO   | PRI | NULL    |       |
+-----------------------+---------------------+------+-----+---------+-------+

Indexe

MediaWiki Versions:

1.30 – 1.40

SHOW INDEX IN revision_comment_temp;

+-----------------------+------------+----------------+--------------+-----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table                 | Non_unique | Key_name       | Seq_in_index | Column_name           | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------------------+------------+----------------+--------------+-----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| revision_comment_temp |          0 | PRIMARY        |            1 | revcomment_rev        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| revision_comment_temp |          0 | PRIMARY        |            2 | revcomment_comment_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| revision_comment_temp |          0 | revcomment_rev |            1 | revcomment_rev        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+-----------------------+------------+----------------+--------------+-----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+