arunravimv commented on issue #33647: URL: https://github.com/apache/airflow/issues/33647#issuecomment-2094577106
Hi Airflow Community, we faced the same issue on Airflow 2.7.3 (using AWS RDS MySql 8.0.35). For large airflow deployments with 1000s of active dags and large volume of records in TI table we think that this query is not making use of ti_trigger_id index. Here is a snapshot of MySQL explain forcing it work on all rows in TI table. <img width="1528" alt="Screenshot 2024-05-05 at 12 19 30 PM" src="https://github.com/apache/airflow/assets/8220318/d9f6873a-acc9-4ec1-be71-0986fd82355c";> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@airflow.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
