Works better, thanks a lot
Am Do., 12. März 2026 um 22:26 Uhr schrieb AntiCompositeNumber via Wikitech-l <[email protected]>: > > 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/ _______________________________________________ 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/
