You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2016/06/30 21:34:10 UTC
[jira] [Commented] (AIRFLOW-291) Add an index for
task_instance.state
[ https://issues.apache.org/jira/browse/AIRFLOW-291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15357893#comment-15357893 ]
ASF subversion and git services commented on AIRFLOW-291:
---------------------------------------------------------
Commit 7980f7771ab6b6f84259ea9a52e78e4f5f690e42 in incubator-airflow's branch refs/heads/master from [~aoen]
[ https://git-wip-us.apache.org/repos/asf?p=incubator-airflow.git;h=7980f77 ]
[AIRFLOW-291] Add index for state in TI table
Closes #1635 from aoen/ddavydov/add_index_to_task_instance_state
> 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
>
> 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)