Transitions - Indexes and Oops

[mcawilcox (Mike Wilcox)]

I’ve put a post in the General section on Transitions, and an Oops timeout, adding indexes to fix, and possibly needing more indexing.

I think my question has strayed from being general into a support aspect, so I’ve added this link to it here:

Transitions execution time - Oops

Hi, We have a high traffic site, with plenty of work done to make use of queued tracking and cron-based archiving. Now we’re hitting the point where transitions are giving us an Oops message later in the day. I understand these are live queries, rather than archiving-based, and from the code, it looks like the queries themselves are governed by the ‘live_query_max_execution_time’ setting. When I change this setting to 300, I can see the hint be included in the query to the database. However,…