If you were querying by `cl_to`, your new queries need to add an `AND lt_namespace = 14`, either to the JOIN statement or the WHERE clause. Both `lt_title` and `lt_namespace` are required for the compound index to work.
If that isn't the issue, please check the EXPLAIN with https://sql-optimizer.toolforge.org/ and send your query here. AntiCompositeNumber (they/them) On Thu, Mar 12, 2026, at 15:48, Martin Domdey via Wikitech-l wrote: > Thank you, but bot flagged database queries with cl_target_id instead > of cl_to are very slow now. Queries with cl_to have been VERY faster. > > Am Do., 12. März 2026 um 18:42 Uhr schrieb Francesco Negri via > Wikitech-l <[email protected]>: >> >> > On Thu, Mar 12, 2026 at 10:15:23AM -0700, JJMC89 via Wikitech-l wrote: >> > > You should have migrated before 1 March. This was annonced in >> > > https://lists.wikimedia.org/hyperkitty/list/[email protected]/message/2LYOH46IXCOPHGVYRULQPYFLUP5TE4VG/ >> >> To give some more details: the change was merged on March, 2nd [0] but >> this type of changes is not applied automatically on merge. I applied >> it today to all Wiki Replicas dbs. [1] >> >> The change was announced one month ago in the cloud-announce message >> linked above. In retrospect, I think it would have been useful to also >> announce it in wikitech-l and/or in Tech News, it's something we can >> consider for similar changes in the future. >> >> [0] https://gerrit.wikimedia.org/r/c/operations/puppet/+/1239483 >> [1] https://phabricator.wikimedia.org/T417492 >> >> -- >> Francesco Negri (he/him) -- IRC: dhinus >> Site Reliability Engineer, Tools Platform >> Wikimedia Foundation >> _______________________________________________ >> Wikitech-l mailing list -- [email protected] >> To unsubscribe send an email to [email protected] >> https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/ > _______________________________________________ > Wikitech-l mailing list -- [email protected] > To unsubscribe send an email to [email protected] > https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/ _______________________________________________ Wikitech-l mailing list -- [email protected] To unsubscribe send an email to [email protected] https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/
