[
https://issues.apache.org/jira/browse/AIRFLOW-291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chris Riccomini closed AIRFLOW-291.
-----------------------------------
Resolution: Fixed
Fix Version/s: Airflow 1.8
> Add an index for task_instance.state
> ------------------------------------
>
> Key: AIRFLOW-291
> URL: https://issues.apache.org/jira/browse/AIRFLOW-291
> Project: Apache Airflow
> Issue Type: Improvement
> Reporter: Dan Davydov
> Assignee: Dan Davydov
> Labels: database, scalability
> Fix For: Airflow 1.8
>
>
> Add an index for task_instance.state to speed up querying for currently
> queued/running tasks.
> From my experimentation at Airbnb on our mysql DB this has shown about a
> 15-40% decrease in the number of mysql connections depending on qps and has
> brought down CPU usage of the DB from constant spikes of 100% to 2%.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
