[betalabs] enwiki - ref_src_wiki column is missing from v2 index
Closed, ResolvedPublic

Description

Split from T111084.

ref_src_wiki column in flow_wiki_ref is not included in v2 index in enwiki.

 [enwiki]> show index from flow_wiki_ref ;
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table         | Non_unique | Key_name                  | Seq_in_index | Column_name          | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            1 | ref_src_namespace    | A         |           8 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            2 | ref_src_title        | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            3 | ref_type             | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            4 | ref_target_namespace | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            5 | ref_target_title     | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            6 | ref_src_object_type  | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            7 | ref_src_object_id    | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            1 | ref_src_namespace    | A         |          14 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            2 | ref_src_title        | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            3 | ref_src_object_type  | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            4 | ref_src_object_id    | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            5 | ref_type             | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            6 | ref_target_namespace | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            7 | ref_target_title     | A         |        2651 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
14 rows in set (0.00 sec)

vs

[testwiki]> show index from flow_wiki_ref ;
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table         | Non_unique | Key_name                  | Seq_in_index | Column_name          | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            1 | ref_src_wiki         | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            2 | ref_src_namespace    | A         |          26 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            3 | ref_src_title        | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            4 | ref_type             | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            5 | ref_target_namespace | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            6 | ref_target_title     | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            7 | ref_src_object_type  | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            8 | ref_src_object_id    | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            1 | ref_src_wiki         | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            2 | ref_src_namespace    | A         |          19 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            3 | ref_src_title        | A         |         296 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            4 | ref_src_object_type  | A         |         296 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            5 | ref_src_object_id    | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            6 | ref_type             | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            7 | ref_target_namespace | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            8 | ref_target_title     | A         |         592 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
16 rows in set (0.00 sec)
Etonkovidova updated the task description. (Show Details)
Etonkovidova raised the priority of this task from to Needs Triage.
Etonkovidova assigned this task to Catrope.
Etonkovidova added a subscriber: Etonkovidova.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 23 2015, 8:45 PM
Catrope closed this task as Resolved.Sep 23 2015, 10:00 PM
mysql> show index from flow_wiki_ref;
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table         | Non_unique | Key_name                  | Seq_in_index | Column_name          | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            1 | ref_src_wiki         | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            2 | ref_src_namespace    | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            3 | ref_src_title        | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            4 | ref_type             | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            5 | ref_target_namespace | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            6 | ref_target_title     | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            7 | ref_src_object_type  | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_idx_v2      |            8 | ref_src_object_id    | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            1 | ref_src_wiki         | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            2 | ref_src_namespace    | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            3 | ref_src_title        | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            4 | ref_src_object_type  | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            5 | ref_src_object_id    | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            6 | ref_type             | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            7 | ref_target_namespace | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
| flow_wiki_ref |          1 | flow_wiki_ref_revision_v2 |            8 | ref_target_title     | A         |         192 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+---------------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
16 rows in set (0.00 sec)

mysql> show index from flow_ext_ref;
+--------------+------------+--------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table        | Non_unique | Key_name                 | Seq_in_index | Column_name         | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+--------------+------------+--------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            1 | ref_src_wiki        | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            2 | ref_src_namespace   | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            3 | ref_src_title       | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            4 | ref_type            | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            5 | ref_target          | A         |          91 |      255 | NULL   | YES  | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            6 | ref_src_object_type | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_idx_v2      |            7 | ref_src_object_id   | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            1 | ref_src_wiki        | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            2 | ref_src_namespace   | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            3 | ref_src_title       | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            4 | ref_src_object_type | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            5 | ref_src_object_id   | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            6 | ref_type            | A         |          91 |     NULL | NULL   |      | BTREE      |         |               |
| flow_ext_ref |          1 | flow_ext_ref_revision_v2 |            7 | ref_target          | A         |          91 |      255 | NULL   | YES  | BTREE      |         |               |
+--------------+------------+--------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
14 rows in set (0.01 sec)