Anomie added a comment.
| 1 | SIMPLE | wb_entity_per_page | index |
wb_epp_entity,wb_epp_page | wb_epp_page | 4 | NULL
| 23158153 | Using where; Using index |
It's deciding to do a scan on the whole `wb_epp_page` index (estimated to be
23 million rows!) instead of using the `wb_epp_entity` index to fetch the
up-to-292 matching rows, which is obviously going to take a very long time.
Possibly it does this because the one bogus `(epp_entity_id = '502560238080'
AND epp_entity_type = 'item')` has a value that exceeds the range of `int(10)
unsigned` for the `epp_entity_id` field so it thinks it can't manage to use the
index instead of realizing that one is just impossible.
Interestingly, if the number isn't quoted (i.e. `epp_entity_id =
502560238080`), it does go ahead with the proper index.
If you want to dig deeper into that sort of database-y goodness, you'd
probably want to ask jcrespo.
TASK DETAIL
https://phabricator.wikimedia.org/T131026
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Anomie
Cc: Anomie, hoo, Addshore, intracer, Ata, Base, Aklapper, Sethakill, dg711,
D3r1ck01, Izno, Wikidata-bugs, aude, jayvdb, fbstj, Mbch331, Legoktm
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
