| Ladsgroup added a comment. |
It's not done in s8 eqiad causing this T207313: Some administrative and log actions on Wikidata take longer than 60 seconds and time out on Wikidata:
[email protected](wikidatawiki)> show index from change_tag; +------------+------------+----------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------+------------+----------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | change_tag | 0 | PRIMARY | 1 | ct_id | A | 222003497 | NULL | NULL | | BTREE | | | | change_tag | 0 | change_tag_rc_tag | 1 | ct_rc_id | A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_rc_tag | 2 | ct_tag | A | 222003497 | NULL | NULL | | BTREE | | | | change_tag | 0 | change_tag_log_tag | 1 | ct_log_id | A | 1060 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_log_tag | 2 | ct_tag | A | 41210 | NULL | NULL | | BTREE | | | | change_tag | 0 | change_tag_rev_tag | 1 | ct_rev_id | A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_rev_tag | 2 | ct_tag | A | 222003497 | NULL | NULL | | BTREE | | | | change_tag | 1 | change_tag_tag_id | 1 | ct_tag | A | 30971 | NULL | NULL | | BTREE | | | | change_tag | 1 | change_tag_tag_id | 2 | ct_rc_id | A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id | 3 | ct_rev_id | A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id | 4 | ct_log_id | A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id_id | 1 | ct_tag_id | A | 33591 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id_id | 2 | ct_rc_id | A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id_id | 3 | ct_rev_id | A | 222003497 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id_id | 4 | ct_log_id | A | 222003497 | NULL | NULL | YES | BTREE | | | +------------+------------+----------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 15 rows in set (0.00 sec)
(Compare it with enwiki):
[email protected](enwiki)> show index from change_tag; +------------+------------+----------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------+------------+----------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | change_tag | 0 | PRIMARY | 1 | ct_id | A | 56055095 | NULL | NULL | | BTREE | | | | change_tag | 0 | change_tag_rc_tag_id | 1 | ct_rc_id | A | 56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_rc_tag_id | 2 | ct_tag_id | A | 56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_log_tag_id | 1 | ct_log_id | A | 2242203 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_log_tag_id | 2 | ct_tag_id | A | 50363 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_rev_tag_id | 1 | ct_rev_id | A | 56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | change_tag_rev_tag_id | 2 | ct_tag_id | A | 56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id | 1 | ct_tag | A | 36423 | NULL | NULL | | BTREE | | | | change_tag | 1 | change_tag_tag_id | 2 | ct_rc_id | A | 56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id | 3 | ct_rev_id | A | 56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id | 4 | ct_log_id | A | 56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id_id | 1 | ct_tag_id | A | 44629 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id_id | 2 | ct_rc_id | A | 56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id_id | 3 | ct_rev_id | A | 56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_tag_id_id | 4 | ct_log_id | A | 56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_rc_tag_nonuniq | 1 | ct_rc_id | A | 56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_rc_tag_nonuniq | 2 | ct_tag | A | 56055095 | NULL | NULL | | BTREE | | | | change_tag | 1 | change_tag_log_tag_nonuniq | 1 | ct_log_id | A | 849319 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_log_tag_nonuniq | 2 | ct_tag | A | 39447 | NULL | NULL | | BTREE | | | | change_tag | 1 | change_tag_rev_tag_nonuniq | 1 | ct_rev_id | A | 56055095 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | change_tag_rev_tag_nonuniq | 2 | ct_tag | A | 56055095 | NULL | NULL | | BTREE | | | +------------+------------+----------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 21 rows in set (0.00 sec)FYI. That wasted two days of mine trying to understand what is wrong with the query and trying to find a better query for that
TASK DETAIL
EMAIL PREFERENCES
To: Marostegui, Ladsgroup
Cc: Stashbot, Marostegui, Tgr, Anomie, TTO, Catrope, Aklapper, gerritbot, Ladsgroup, Nandana, Banyek, Rayssa-, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Jonas, MGChecker, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, Jay8g, Krenair
Cc: Stashbot, Marostegui, Tgr, Anomie, TTO, Catrope, Aklapper, gerritbot, Ladsgroup, Nandana, Banyek, Rayssa-, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Jonas, MGChecker, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
