Dan Davydov created AIRFLOW-291:
-----------------------------------
Summary: 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
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)
