You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@airflow.apache.org by "Chris Riccomini (JIRA)" <ji...@apache.org> on 2016/06/30 21:35:10 UTC

[jira] [Closed] (AIRFLOW-291) Add an index for task_instance.state

     [ 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)