| Marostegui added a comment. |
I have run an analyze table on both db1109 and db2083 and things are similar now:
db1109 +---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | wb_changes_dispatch | 0 | PRIMARY | 1 | chd_site | A | 577 | NULL | NULL | | BTREE | | | | wb_changes_dispatch | 1 | wb_changes_dispatch_chd_seen | 1 | chd_seen | A | 456 | NULL | NULL | | BTREE | | | | wb_changes_dispatch | 1 | wb_changes_dispatch_chd_touched | 1 | chd_touched | A | 264 | NULL | NULL | | BTREE | | | +---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ db2083 +---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | wb_changes_dispatch | 0 | PRIMARY | 1 | chd_site | A | 577 | NULL | NULL | | BTREE | | | | wb_changes_dispatch | 1 | wb_changes_dispatch_chd_seen | 1 | chd_seen | A | 455 | NULL | NULL | | BTREE | | | | wb_changes_dispatch | 1 | wb_changes_dispatch_chd_touched | 1 | chd_touched | A | 243 | NULL | NULL | | BTREE | | | +---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
TASK DETAIL
EMAIL PREFERENCES
To: Marostegui
Cc: gerritbot, aaron, hoo, Joe, User-Marostegui, Banyek, jcrespo, Marostegui, Addshore, Aklapper, CucyNoiD, Nandana, NebulousIris, jijiki, AndyTan, Gaboe420, Phukettaxigroup, Versusxo, Majesticalreaper22, Giuliamocci, Davinaclare77, Adrian1985, Qtn1293, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Jayprakash12345, Th3d3v1ls, Hfbn0, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Minhnv-2809, Zppix, Volans, Maathavan, D3r1ck01, Volker_E, Wong128hk, Luke081515, Wikidata-bugs, aude, GWicke, Dinoguy1000, faidon, Mbch331, Jay8g, Krenair, akosiaris, fgiunchedi
Cc: gerritbot, aaron, hoo, Joe, User-Marostegui, Banyek, jcrespo, Marostegui, Addshore, Aklapper, CucyNoiD, Nandana, NebulousIris, jijiki, AndyTan, Gaboe420, Phukettaxigroup, Versusxo, Majesticalreaper22, Giuliamocci, Davinaclare77, Adrian1985, Qtn1293, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Jayprakash12345, Th3d3v1ls, Hfbn0, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Minhnv-2809, Zppix, Volans, Maathavan, D3r1ck01, Volker_E, Wong128hk, Luke081515, Wikidata-bugs, aude, GWicke, Dinoguy1000, faidon, Mbch331, Jay8g, Krenair, akosiaris, fgiunchedi
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
