[codesprints] Resources to help with the performance codesprint on 27-28 Oct
Robert Sparks <rjsparks@nostrum.com> Tue, 12 October 2021 21:59 UTC
Return-Path: <rjsparks@nostrum.com>
X-Original-To: codesprints@ietfa.amsl.com
Delivered-To: codesprints@ietfa.amsl.com
Received: from localhost (localhost [127.0.0.1]) by ietfa.amsl.com (Postfix) with ESMTP id 8BDB03A0BB2 for <codesprints@ietfa.amsl.com>; Tue, 12 Oct 2021 14:59:16 -0700 (PDT)
X-Virus-Scanned: amavisd-new at amsl.com
X-Spam-Flag: NO
X-Spam-Score: -2.079
X-Spam-Level:
X-Spam-Status: No, score=-2.079 tagged_above=-999 required=5 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, T_SPF_HELO_PERMERROR=0.01, T_SPF_PERMERROR=0.01, URIBL_BLOCKED=0.001] autolearn=ham autolearn_force=no
Authentication-Results: ietfa.amsl.com (amavisd-new); dkim=pass (1024-bit key) header.d=nostrum.com
Received: from mail.ietf.org ([4.31.198.44]) by localhost (ietfa.amsl.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id YMx17YHV-hT5 for <codesprints@ietfa.amsl.com>; Tue, 12 Oct 2021 14:59:10 -0700 (PDT)
Received: from nostrum.com (raven-v6.nostrum.com [IPv6:2001:470:d:1130::1]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by ietfa.amsl.com (Postfix) with ESMTPS id E73AA3A0BAC for <codesprints@ietf.org>; Tue, 12 Oct 2021 14:59:08 -0700 (PDT)
Received: from [192.168.1.114] ([47.186.34.206]) (authenticated bits=0) by nostrum.com (8.17.1/8.16.1) with ESMTPSA id 19CLx5q5073657 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NO) for <codesprints@ietf.org>; Tue, 12 Oct 2021 16:59:05 -0500 (CDT) (envelope-from rjsparks@nostrum.com)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=nostrum.com; s=default; t=1634075945; bh=libRFiXoP02GpxuZXQr8i2LqMRMPdaR1mWohIMh7fuc=; h=Date:To:From:Subject; b=AhtN7FqresXS5XyibmY/LSf82j7j9T+/jJfo7Zo9zYpAoukLE6ySVYM5xmtMT1WKW AlXDaykRJcVnbgTNwRXUMtazhcirELI2o9XTsL9qzZbMlgU+Afe2i874RFYl9+swrj mX3JzLSRjJciBUlt8PGExyfjD7Um9FlqvmsiavBQ=
X-Authentication-Warning: raven.nostrum.com: Host [47.186.34.206] claimed to be [192.168.1.114]
Message-ID: <5583c653-5152-beb0-b962-536201efa691@nostrum.com>
Date: Tue, 12 Oct 2021 16:59:00 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.2.0
Content-Language: en-US
To: IETF Codesprints <codesprints@ietf.org>
From: Robert Sparks <rjsparks@nostrum.com>
Content-Type: text/plain; charset="UTF-8"; format="flowed"
Content-Transfer-Encoding: 7bit
Archived-At: <https://mailarchive.ietf.org/arch/msg/codesprints/Wc8E7IR1-g2FxC-MYGGX-GQhzBY>
Subject: [codesprints] Resources to help with the performance codesprint on 27-28 Oct
X-BeenThere: codesprints@ietf.org
X-Mailman-Version: 2.1.29
Precedence: list
List-Id: "List for coordinating \(and following up on\) codesprint activities" <codesprints.ietf.org>
List-Unsubscribe: <https://www.ietf.org/mailman/options/codesprints>, <mailto:codesprints-request@ietf.org?subject=unsubscribe>
List-Archive: <https://mailarchive.ietf.org/arch/browse/codesprints/>
List-Post: <mailto:codesprints@ietf.org>
List-Help: <mailto:codesprints-request@ietf.org?subject=help>
List-Subscribe: <https://www.ietf.org/mailman/listinfo/codesprints>, <mailto:codesprints-request@ietf.org?subject=subscribe>
X-List-Received-Date: Tue, 12 Oct 2021 21:59:17 -0000
There are slow-query logs for the last week, and dumps of the relevant
rows information_schema.{tables|table_statistics|index_statistics}
available at the same place as the development database dumps now. They
are updated daily.
You can get them from the following urls (through cloudflare):
https://www.ietf.org/lib/dt/sprint/dt_info.sql.gz
https://www.ietf.org/lib/dt/sprint/ietf_utf8_slow.log
https://www.ietf.org/lib/dt/sprint/mailarch_info.sql.gz
https://www.ietf.org/lib/dt/sprint/mailarch_slow.log
RjS
- [codesprints] Resources to help with the performa… Robert Sparks