[Wikidata-bugs] [Maniphest] [Edited] T202265: Add 'tmp1' index that is in WMF production to the Wikibase install SQL files

[Addshore]

Addshore updated the task description. (Show Details)

CHANGES TO TASK DESCRIPTION

...

- A comment next to the index should be added pointing to this ticket so it can easily be found if a developer looks at the code in 2 years time.

**SQL Details**

As of 20/08/2018


```
MariaDB [wikidatawiki]> describe wb_terms;
+---------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+---------------------+------+-----+---------+----------------+
| term_row_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| term_entity_id | int(10) unsigned | NO | MUL | NULL | |
| term_full_entity_id | varbinary(32) | YES | MUL | NULL | |
| term_entity_type | varbinary(32) | NO | | NULL | |
| term_language | varbinary(32) | NO | MUL | NULL | |
| term_type | varbinary(32) | NO | | NULL | |
| term_text | varbinary(255) | NO | MUL | NULL | |
| term_search_key | varbinary(255) | NO | MUL | NULL | |
| term_weight | float unsigned | NO | | 0 | |
+---------------------+---------------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)
MariaDB [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 | 1682161570 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | wb_terms_entity_id | 1 | term_entity_id | A | 98950680 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | wb_terms_text | 1 | term_text | A | 240308795 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | wb_terms_search_key | 1 | term_search_key | A | 64698521 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_full_entity | 1 | term_full_entity_id | A | 112144104 | NULL | NULL | YES | BTREE | | |
| wb_terms | 1 | term_search_full | 1 | term_language | A | 7067905 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_search_full | 2 | term_full_entity_id | A | 1682161570 | NULL | NULL | YES | BTREE | | |
| wb_terms | 1 | term_search_full | 3 | term_type | A | 1682161570 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_search_full | 4 | term_search_key | A | 1682161570 | 16 | NULL | | BTREE | | |
| wb_terms | 1 | tmp1 | 1 | term_language | A | 6184417 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | tmp1 | 2 | term_type | A | 6979923 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | tmp1 | 3 | term_entity_type | A | 8048619 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | tmp1 | 4 | term_search_key | A | 560720523 | NULL | NULL | | BTREE | | |
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
13 rows in set (0.00 sec)
```

TASK DETAIL

https://phabricator.wikimedia.org/T202265

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Addshore
Cc: Ladsgroup, Addshore, Aklapper, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs