Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id D6BB5200498 for ; Tue, 29 Aug 2017 20:02:41 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id D4FE81673EE; Tue, 29 Aug 2017 18:02:41 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 286821673EB for ; Tue, 29 Aug 2017 20:02:41 +0200 (CEST) Received: (qmail 13178 invoked by uid 500); 29 Aug 2017 18:02:38 -0000 Mailing-List: contact dev-help@airflow.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@airflow.incubator.apache.org Delivered-To: mailing list dev@airflow.incubator.apache.org Received: (qmail 13166 invoked by uid 99); 29 Aug 2017 18:02:37 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Aug 2017 18:02:37 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 83799188B3F for ; Tue, 29 Aug 2017 18:02:37 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id yi6iBYWE4koh for ; Tue, 29 Aug 2017 18:02:36 +0000 (UTC) Received: from mail-wm0-f47.google.com (mail-wm0-f47.google.com [74.125.82.47]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id B30F360EF3 for ; Tue, 29 Aug 2017 18:02:35 +0000 (UTC) Received: by mail-wm0-f47.google.com with SMTP id u26so2568609wma.0 for ; Tue, 29 Aug 2017 11:02:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=/affubFErb7aE84Dg8GJeDZKB8y1A/iUMACSXSIoN0c=; b=iXeQFW32c1mFHhiyBf2gyFWyBL/6boEzbgA25y3KVdY8z6aSjwVNWyXdUUaz5WcFH9 aQg4ryFAktTKGxXoLCjewtpaziSQLjg5OeOeQrV4hI0i7Li453arz55rj4ZpiWqFbfwB dYhby2FV2B5KpUVlcwKS1AUvqQiVRP1CaiBFzDTd+Z3vxlZWczX29Vjjdoel/NqFTvDx fPFegiDkrpL0PVVC5qi5UzzjSWs58d7Yw+S7Bw/0w90rpZyHFWXgvsFPZ0XroBF0aM2e ZjJmX4TH9Kr0YnF2DSmMirCqaNo0SynRotg8SQHt0uVvrCOwokH0Hnm29Zviz78uYlyY D/WA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=/affubFErb7aE84Dg8GJeDZKB8y1A/iUMACSXSIoN0c=; b=uCaOa8xbCeoLfuO4FvTCDulO5O+OwHxuyElFIklqBmuhFTgYahdDM7q2eKJ2kik3Ct dat+3VqdtWkCRwZOg8n22e8VTVYLBngUUe7ghe+5CCJj+jb6GM7ZNciN0mSEx7gRuqrQ PdQJZDH45VhQqbeZ0jGr3Gpyir71nCfKk2xTWPWFNJcqHHi1rwgiQw6qXlB6Nh/Ki28y pZH+Y31w+CWWJ5NTtmkPl59Mrm58yyH4jWvzRjazcsUg5w8wef1HuPYEFMhZOyBNMcU2 rpjmSfblCM+sc+02MitUE1DOmhzMoJPVO6TMrnNxbCRPLY+BkGcytyBA+q8MCxAs/tWV l5aA== X-Gm-Message-State: AHYfb5jOjQakURmOxxK132hdVMNakrB5YTwbEH+DkVwbnwd09Qty+t7K cid1EFg/hOxlrQ3i8+y9Aqj5LAE5tA== X-Received: by 10.80.140.240 with SMTP id r45mr4315187edr.181.1504029754818; Tue, 29 Aug 2017 11:02:34 -0700 (PDT) MIME-Version: 1.0 Received: by 10.80.154.228 with HTTP; Tue, 29 Aug 2017 11:02:33 -0700 (PDT) Received: by 10.80.154.228 with HTTP; Tue, 29 Aug 2017 11:02:33 -0700 (PDT) In-Reply-To: References: From: David Capwell Date: Tue, 29 Aug 2017 11:02:33 -0700 Message-ID: Subject: Re: As history grows UI gets slower To: dev@airflow.incubator.apache.org Content-Type: multipart/alternative; boundary="94eb2c1954ea4484de0557e837cf" archived-at: Tue, 29 Aug 2017 18:02:42 -0000 --94eb2c1954ea4484de0557e837cf Content-Type: text/plain; charset="UTF-8" Thanks, will take a look at this project On Aug 29, 2017 10:35 AM, "Chris Riccomini" wrote: > Might have a look at this, too: > > https://github.com/teamclairvoyant/airflow-maintenance-dags > > I haven't used it, but it seems to have a DB cleaning script. > > On Mon, Aug 28, 2017 at 3:43 PM, Maxime Beauchemin < > maximebeauchemin@gmail.com> wrote: > > > Just make sure to archive based on start_date and not execution_date to > > allow backfills. > > > > Max > > > > On Mon, Aug 28, 2017 at 3:20 PM, Alex Guziel > invalid > > > wrote: > > > > > Here at Airbnb we delete old "completed" task instances. > > > > > > On Mon, Aug 28, 2017 at 3:01 PM, David Capwell > > wrote: > > > > > > > We are on 1.8.0 and have a monitor DAG that monitors the health of > > > Airflow > > > > and Celery every minute. This has been running for awhile now and at > > 26k > > > > dag runs. We see that the UI for this DAG is multiple seconds slower > > (6-7 > > > > second) than any other DAG. > > > > > > > > My question is, what do people do about managing history as it grows > > over > > > > time? Do people delete history after N or so days? > > > > > > > > Thanks for your time reading this email > > > > > > > > > > --94eb2c1954ea4484de0557e837cf--