daniel added a comment. Proposal for a solution that does not need knowledge about how the parser cache is split:
Split the update into two steps: 1. a SELECT query using the WHERE clause we currently see in the UPDATE query, collecting all the matching eu_row_ids. 2. an UPDATE query using the row ids to identify the rows to be updated. This needs more resources overall, but hopefully reduces lock retention time and overall load on the master db. TASK DETAIL https://phabricator.wikimedia.org/T107319 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: daniel Cc: JanZerebecki, daniel, hoo, Addshore, Lydia_Pintscher, ori, jcrespo, Aklapper, aude, Wikidata-bugs, Malyacko _______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
