You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "amit-mittal (via GitHub)" <gi...@apache.org> on 2025/07/18 19:01:23 UTC
[I] Duplicate indices on MySQL [airflow]
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: commits-unsubscribe@airflow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Duplicate indices on MySQL [airflow]
Posted by "potiuk (via GitHub)" <gi...@apache.org>.
potiuk commented on issue #53509:
URL: https://github.com/apache/airflow/issues/53509#issuecomment-3092467937
Feel free
--
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-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Duplicate indices on MySQL [airflow]
Posted by "kyungjunleeme (via GitHub)" <gi...@apache.org>.
kyungjunleeme commented on issue #53509:
URL: https://github.com/apache/airflow/issues/53509#issuecomment-3092142182
I could help this issue, If I assigned.
--
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-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Duplicate indices on MySQL [airflow]
Posted by "potiuk (via GitHub)" <gi...@apache.org>.
potiuk commented on issue #53509:
URL: https://github.com/apache/airflow/issues/53509#issuecomment-3841454962
It always is - even if people are assigned.
--
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-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Duplicate indices on MySQL [airflow]
Posted by "amit-mittal (via GitHub)" <gi...@apache.org>.
amit-mittal commented on issue #53509:
URL: https://github.com/apache/airflow/issues/53509#issuecomment-3761043446
Since assignee is not planning to work on it, should we unassign these, so these are up for grabs again?
--
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-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org