amit-mittal opened a new issue, #53509: URL: https://github.com/apache/airflow/issues/53509
### Apache Airflow version 3.0.3 ### If "Other Airflow 2 version" selected, which one? _No response_ ### What happened? We are checking the indices that Airflow creates on different tables to find any performance issues and we noticed on `MySQL`, there are duplicate indices created on `dag_run` table: - KEY `idx_dag_run_running_dags` (`state`,`dag_id`) - KEY `idx_dag_run_queued_dags` (`state`,`dag_id`) Even though index/key names are different, since the columns and their order are same, it is essentially the duplicate. And this will effect any `INSERT` operations and potentially `SELECT` statements too, since `MySQL` will be confused about which index among the duplicates should be used. ### What you think should happen instead? _No response_ ### How to reproduce N/A ### Operating System MySQL ### Versions of Apache Airflow Providers _No response_ ### Deployment Other Docker-based deployment ### Deployment details MySQL v8.0 ### Anything else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md) -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
