| Addshore added a comment. |
So I just diffed the tables and indexes on production wikidatawiki vs my local fresh install, the result can be found @ https://www.diffchecker.com/BGjXnosI.
The only differences are on the wb_terms indexes:
On prod:
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | 1717619563 | NULL | NULL | | BTREE | | | | wb_terms | 1 | wb_terms_entity_id | 1 | term_entity_id | A | 156147233 | NULL | NULL | | BTREE | | | | wb_terms | 1 | wb_terms_text | 1 | term_text | A | 429404890 | NULL | NULL | | BTREE | | | | wb_terms | 1 | wb_terms_search_key | 1 | term_search_key | A | 156147233 | NULL | NULL | | BTREE | | | | wb_terms | 1 | term_full_entity | 1 | term_full_entity_id | A | 85880978 | NULL | NULL | YES | BTREE | | | | wb_terms | 1 | term_search_full | 1 | term_language | A | 6580917 | NULL | NULL | | BTREE | | | | wb_terms | 1 | term_search_full | 2 | term_full_entity_id | A | 1717619563 | NULL | NULL | YES | BTREE | | | | wb_terms | 1 | term_search_full | 3 | term_type | A | 1717619563 | NULL | NULL | | BTREE | | | | wb_terms | 1 | term_search_full | 4 | term_search_key | A | 1717619563 | 16 | NULL | | BTREE | | | | wb_terms | 1 | tmp1 | 1 | term_language | A | 6982193 | NULL | NULL | | BTREE | | | | wb_terms | 1 | tmp1 | 2 | term_type | A | 6709451 | NULL | NULL | | BTREE | | | | wb_terms | 1 | tmp1 | 3 | term_entity_type | A | 8718881 | NULL | NULL | | BTREE | | | | wb_terms | 1 | tmp1 | 4 | term_search_key | A | 429404890 | NULL | NULL | | BTREE | | | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 13 rows in set (0.00 sec)
On my local install:
MariaDB [default]> 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 | 4 | NULL | NULL | | BTREE | | | | wb_terms | 1 | term_full_entity | 1 | term_full_entity_id | A | 4 | NULL | NULL | YES | BTREE | | | | wb_terms | 1 | term_text | 1 | term_text | A | 4 | NULL | NULL | | BTREE | | | | wb_terms | 1 | term_text | 2 | term_language | A | 4 | NULL | NULL | | BTREE | | | | wb_terms | 1 | term_search_key | 1 | term_search_key | A | 4 | NULL | NULL | | BTREE | | | | wb_terms | 1 | term_search_key | 2 | term_language | A | 4 | NULL | NULL | | BTREE | | | | wb_terms | 1 | term_search_full | 1 | term_language | A | 4 | NULL | NULL | | BTREE | | | | wb_terms | 1 | term_search_full | 2 | term_full_entity_id | A | 4 | NULL | NULL | YES | BTREE | | | | wb_terms | 1 | term_search_full | 3 | term_type | A | 4 | NULL | NULL | | BTREE | | | | wb_terms | 1 | term_search_full | 4 | term_search_key | A | 4 | 16 | NULL | | BTREE | | | +----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 10 rows in set (0.001 sec)Summary:
- Things that are the same:
- PRIMARY is the same :)
- term_full_entity is the same :)
- term_search_full is the same :)
- Things only in prod:
- wb_terms_entity_id is only in prod
- wb_terms_text is only in prod
- wb_terms_search_key is only in prod
- tmp1 is only in prod (already tracked as T202265)
- Things that are only local:
- term_text is only on my local install
- term_search_key is only on my local install
So the differences:
- tmp1 we are already tracking as T202265
- indexes that sound similar but appear different, locally they both also cover term_language, on prod they do not:
- term_text and wb_terms_text sound similar but differ
- term_search_key and wb_terms_search_key sound similar but differ
- wb_terms_entity_id is only on prod, no sign of anything resembling it locally.
TASK DETAIL
EMAIL PREFERENCES
To: Addshore
Cc: Addshore, hoo, Ladsgroup, JanZerebecki, aude, Aklapper, daniel, Banyek, AndyTan, Lahi, Gq86, GoranSMilovanovic, QZanden, Marostegui, LawExplorer, Minhnv-2809, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair
Cc: Addshore, hoo, Ladsgroup, JanZerebecki, aude, Aklapper, daniel, Banyek, AndyTan, Lahi, Gq86, GoranSMilovanovic, QZanden, Marostegui, LawExplorer, Minhnv-2809, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
