CommunityTechBot updated the task description. (Show Details) |
CHANGES TO TASK DESCRIPTION
In production tables for wikidatawiki (and testwikidatawiki) these three indexes should stay and everything else must go:
```
test_user@db2083.codfw.wmnet(wikidatawiki)>show index from wb_terms;
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_terms | 0 | PRIMARY | 1 | term_row_id | A | 1585960379 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | wb_terms_text | 1 | term_text | A | 528653459 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_full_entity | 1 | term_full_entity_id | A | 144178216 | NULL | NULL | YES | BTREE | | |
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
3 rows in set (0.03 sec)
```
This means dropping index both from the code base and production (they have diverged for reasons that is unknown to me)
```
test_user@db2083.codfw.wmnet(wikidatawiki)>show index from wb_terms;
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_terms | 0 | PRIMARY | 1 | term_row_id | A | 1585960379 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | wb_terms_text | 1 | term_text | A | 528653459 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_full_entity | 1 | term_full_entity_id | A | 144178216 | NULL | NULL | YES | BTREE | | |
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
3 rows in set (0.03 sec)
```
This means dropping index both from the code base and production (they have diverged for reasons that is unknown to me)
TASK DETAIL
EMAIL PREFERENCES
To: Ladsgroup, CommunityTechBot
Cc: Lydia_Pintscher, Mholloway, Stashbot, Marostegui, Lucas_Werkmeister_WMDE, Jonas, jcrespo, Ladsgroup, AndyTan, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Minhnv-2809, Maathavan, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
Cc: Lydia_Pintscher, Mholloway, Stashbot, Marostegui, Lucas_Werkmeister_WMDE, Jonas, jcrespo, Ladsgroup, AndyTan, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Minhnv-2809, Maathavan, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs