
From nobody Thu Oct  7 12:44:10 2021
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 44E273A0DFC; Thu,  7 Oct 2021 12:43:43 -0700 (PDT)
X-Virus-Scanned: amavisd-new at amsl.com
X-Spam-Flag: NO
X-Spam-Score: -2.08
X-Spam-Level: 
X-Spam-Status: No, score=-2.08 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, NICE_REPLY_A=-0.001, 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 9cvJKsImEVEW; Thu,  7 Oct 2021 12:43:25 -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 0083E3A0DF7; Thu,  7 Oct 2021 12:43:24 -0700 (PDT)
Received: from unformal.localdomain ([47.186.34.206]) (authenticated bits=0) by nostrum.com (8.17.1/8.16.1) with ESMTPSA id 197JhNTr006008 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NO); Thu, 7 Oct 2021 14:43:23 -0500 (CDT) (envelope-from rjsparks@nostrum.com)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=nostrum.com; s=default; t=1633635804; bh=A1dcWMvLxE8RxkQZ/Ld4YFw/xc6N2LEmALC1vMHSpQs=; h=From:To:Cc:References:Subject:Date:In-Reply-To; b=nsfyAKprwc/mNrvcHvSZ9DNd6nhtgyyOH+v+P/1BAraefw1gf/OXuOM5L81SrqrlY m6VSKwVO7k/ASdtZFT4iqJF4ddI63ZMpvsWP6VCGA7c21g0uiDFfLT1u03eOq9ulyM XQOJvj3LADYS4OUnybKNKFns6VU5Fs6Vzi02Wa6E=
X-Authentication-Warning: raven.nostrum.com: Host [47.186.34.206] claimed to be unformal.localdomain
From: Robert Sparks <rjsparks@nostrum.com>
To: tools-discuss <tools-discuss@ietf.org>
Cc: IETF Codesprints <codesprints@ietf.org>
References: <0d8472cb-179a-fb4c-ff7a-d6ec418b50d4@nostrum.com>
Message-ID: <a22535f4-f3d6-5c00-7f53-dbaad8f99a54@nostrum.com>
Date: Thu, 7 Oct 2021 14:43:18 -0500
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Thunderbird/78.14.0
MIME-Version: 1.0
In-Reply-To: <0d8472cb-179a-fb4c-ff7a-d6ec418b50d4@nostrum.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Language: en-US
Archived-At: <https://mailarchive.ietf.org/arch/msg/codesprints/VP_LYf_PMBmBloISxSsaVMogVeM>
Subject: Re: [codesprints] Performance oriented codesprint before IETF 112
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: Thu, 07 Oct 2021 19:43:44 -0000

Given the doodle results, my plan is to have the primary sprint 27 Oct=20
1600-2000 UTC. People can join or leave as convenient. Coordinates will=20
be sent soon.

I will also have a conference set up for 28 Oct at those same times for=20
followup and for anyone who can't participate on the 27th.

I plan to make resources for analyzing performance available well before =

the sprint. Future communication on that topic will occur on the=20
codesprints@ list. (If you are interested, please subscribe).

RjS

On 9/29/21 5:23 PM, Robert Sparks wrote:
> We would like to hold a codesprint before IETF 112 focused on=20
> datatracker performance.
>
> We have been improving the instrumentation of the datatracker, and=20
> plan to provide quite a bit of information that will help us focus on=20
> places that will help us most. These include statistic from the=20
> database engine itself, and instrumentation that measures which views=20
> are getting the most use, suffering the worst cumulative performance,=20
> and how those views use the database.
>
> I expect much of the work will be verifying that the database has the=20
> right indices, adjusting views to make better use of the ORM (such as=20
> prefetching data (and not to prefetch too _much_ data), and adjusting=20
> models where the current models are proving to be problematic.
>
> I have a doodle for two different possible times on either Oct 27 or=20
> Oct 28.
>
> If you would like to participate, please add yourself to the doodle.=20
> If the proposed times can't be made to work for you and you would=20
> really like to engage in this kind of sprint, please just add a=20
> comment at the doodle page.
>
> RjS
>
>
>
>


From nobody Fri Oct  8 09:26:57 2021
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 9C8AB3A05E2; Fri,  8 Oct 2021 09:26:55 -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 hG-CKvUS8oQM; Fri,  8 Oct 2021 09:26:51 -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 E69A33A059F; Fri,  8 Oct 2021 09:26:50 -0700 (PDT)
Received: from c445f8b9a0b7 ([47.186.34.206]) (authenticated bits=0) by nostrum.com (8.17.1/8.16.1) with ESMTPSA id 198GQmsv035428 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NO); Fri, 8 Oct 2021 11:26:49 -0500 (CDT) (envelope-from rjsparks@nostrum.com)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=nostrum.com; s=default; t=1633710409; bh=ubIjvgkkdK6wy6JgXdVnIKBfgK2Y8EzrmeccxpElBYo=; h=From:To:Subject:Date; b=c0Ln8/pU3oHtH1oCVlLR3nmvlshC3uzmHmt6aHYKSXtH8jFx9w3dS7p12OltZyAhi xpUNW3/Cw/wneeY1FhRQjvspBssb+FMd0L6sriCVKTiY7x+nAOQU42KUmxBjmD0daC EJxg9FW5Qx2M0Ia/zn2rurMn1F7CF5ZPjpAOZvS8=
X-Authentication-Warning: raven.nostrum.com: Host [47.186.34.206] claimed to be c445f8b9a0b7
Received: from rjsparks by c445f8b9a0b7 with local (Exim 4.92) (envelope-from <rjsparks@nostrum.com>) id 1mYshn-0003za-KU; Fri, 08 Oct 2021 16:26:43 +0000
From: rjsparks@nostrum.com
To: codesprints@ietf.org, iesg@ietf.org, wgchairs@ietf.org
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 8bit
Message-Id: <E1mYshn-0003za-KU@c445f8b9a0b7>
Date: Fri, 08 Oct 2021 16:26:43 +0000
Archived-At: <https://mailarchive.ietf.org/arch/msg/codesprints/_jZ-xvA71v1gtrYJOCWKfowX0ec>
Subject: [codesprints] New datatracker release: v7.39.0
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: Fri, 08 Oct 2021 16:26:56 -0000

Hi,

This is an automatic notification about a new datatracker release, 
v7.39.0, generated when running the mkrelease script.

Release notes:

ietfdb (7.39.0) ietf; urgency=medium

  ** Improved pre-AD abilities, ical content, rfcdiff support, bugfixes.***

  * Merged in [19382] from krathnayake@ietf.org:
    Adds ability to handle garbage API keys. Fixes #3412.  

  * Merged in [19383] from jennifer@painless-security.com:
    Allow pre-ADs to be assigned as responsible for document. 
    Fixes #3229.  

  * Merged in [19384] from jennifer@painless-security.com:
    Update links in iCal description to be more useful. 
    Fixes #3349.  

  * Merged in [19385] from jennifer@painless-security.com:
    Correctly highlight session constraints in the meeting 
    schedule editor. Fixes #3327.  

  * Merged in [19392] from krathnayake@ietf.org:
    Improves API authentication tests. Relates to #3412.  

  * Merged in [19393] from krathnayake@ietf.org:
    Fixes API authentication issue.  

  * Merged in [19396] from rjsparks@nostrum.com:
    Provide a metadata endpoint to assist rfcdiff.pyht.  

  * Added scout-apm to requirements and added settings scaffolding.

 -- Robert Sparks <rjsparks@nostrum.com>  07 Oct 2021 15:20:42 +0000

The new version is available for installation through SVN checkout, with
  'svn checkout https://svn.ietf.org/svn/tools/ietfdb/tags/7.39.0'

For development, copy the new development version instead:
  'svn copy https://svn.ietf.org/svn/tools/ietfdb/tags/dev/7.39.1.dev0' <YOURBRANCH>

Regards,

	Robert Sparks
	(via the mkrelease script)


From nobody Mon Oct 11 06:53:53 2021
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 9546A3A0C08 for <codesprints@ietfa.amsl.com>; Mon, 11 Oct 2021 06:53:49 -0700 (PDT)
X-Virus-Scanned: amavisd-new at amsl.com
X-Spam-Flag: NO
X-Spam-Score: -2.078
X-Spam-Level: 
X-Spam-Status: No, score=-2.078 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, HTML_MESSAGE=0.001, 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 uUbVc1UpJZ7Z for <codesprints@ietfa.amsl.com>; Mon, 11 Oct 2021 06:53:44 -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 C8C233A0C05 for <codesprints@ietf.org>; Mon, 11 Oct 2021 06:53:44 -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 19BDrcUw086859 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NO); Mon, 11 Oct 2021 08:53:39 -0500 (CDT) (envelope-from rjsparks@nostrum.com)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=nostrum.com; s=default; t=1633960419; bh=/vSZeo/oR7EhIPjaRi7UrW9QRb8K2Zi+bJkxmXOCczo=; h=Date:Subject:References:To:Cc:From:In-Reply-To; b=fezO0XAo3pj8bgv1u8IvhZvhudWSYvVN1IAaBx06GesA8EvZSwODIPzYCUAefrtgr 3yvz5XOXQ8/DSRwDnx6wJmMHOkGT+aCUjA43ONdj+XFfJMtPbl3ZDVjTicaMii4oZ0 /jbkIdGwLKLHYzC9fZ6tAzfbTasEYd4s7VAZQgZU=
X-Authentication-Warning: raven.nostrum.com: Host [47.186.34.206] claimed to be [192.168.1.114]
Content-Type: multipart/mixed; boundary="------------pYDFM8b0ODpyryQoJTuBwn3V"
Message-ID: <932aab2a-5a64-8f64-510b-f54ab4d22999@nostrum.com>
Date: Mon, 11 Oct 2021 08:53:33 -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
References: <DD7E95BA-8FEE-4148-94B9-F62020584A47@eggert.org>
Content-Language: en-US
To: IETF Codesprints <codesprints@ietf.org>
From: Robert Sparks <rjsparks@nostrum.com>
In-Reply-To: <DD7E95BA-8FEE-4148-94B9-F62020584A47@eggert.org>
X-Forwarded-Message-Id: <DD7E95BA-8FEE-4148-94B9-F62020584A47@eggert.org>
Archived-At: <https://mailarchive.ietf.org/arch/msg/codesprints/BEjVIrKxP2rRKxRKs-1fj_guods>
Subject: [codesprints] Fwd: [Tools-discuss] Who does datatracker dev using the docker images?
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: Mon, 11 Oct 2021 13:53:50 -0000

This is a multi-part message in MIME format.
--------------pYDFM8b0ODpyryQoJTuBwn3V
Content-Type: multipart/alternative;
 boundary="------------I0wkDqaVBQv9lOt0DU6CSqIN"

--------------I0wkDqaVBQv9lOt0DU6CSqIN
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Sprinters - see below:



-------- Forwarded Message --------
Subject: 	[Tools-discuss] Who does datatracker dev using the docker images?
Date: 	Mon, 11 Oct 2021 13:13:52 +0300
From: 	Lars Eggert <lars@eggert.org>
To: 	Tools Team Discussion <tools-discuss@ietf.org>



--------------I0wkDqaVBQv9lOt0DU6CSqIN
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Sprinters - see below:<br>
    </p>
    <div class="moz-forward-container"><br>
      <br>
      -------- Forwarded Message --------
      <table class="moz-email-headers-table" cellspacing="0"
        cellpadding="0" border="0">
        <tbody>
          <tr>
            <th valign="BASELINE" nowrap="nowrap" align="RIGHT">Subject:
            </th>
            <td>[Tools-discuss] Who does datatracker dev using the
              docker images?</td>
          </tr>
          <tr>
            <th valign="BASELINE" nowrap="nowrap" align="RIGHT">Date: </th>
            <td>Mon, 11 Oct 2021 13:13:52 +0300</td>
          </tr>
          <tr>
            <th valign="BASELINE" nowrap="nowrap" align="RIGHT">From: </th>
            <td>Lars Eggert <a class="moz-txt-link-rfc2396E" href="mailto:lars@eggert.org">&lt;lars@eggert.org&gt;</a></td>
          </tr>
          <tr>
            <th valign="BASELINE" nowrap="nowrap" align="RIGHT">To: </th>
            <td>Tools Team Discussion <a class="moz-txt-link-rfc2396E" href="mailto:tools-discuss@ietf.org">&lt;tools-discuss@ietf.org&gt;</a></td>
          </tr>
        </tbody>
      </table>
      <br>
      <br>
    </div>
  </body>
</html>
--------------I0wkDqaVBQv9lOt0DU6CSqIN--

--------------pYDFM8b0ODpyryQoJTuBwn3V
Content-Type: text/plain; charset=UTF-8; name="Attached Message Part"
Content-Disposition: attachment; filename="Attached Message Part"
Content-Transfer-Encoding: base64

Ci0tQXBwbGUtTWFpbD1fQkQ1MUJCQjUtQTM2NS00OEFDLUIzQ0QtOTRGMjc1MUYxQUUyCkNv
bnRlbnQtVHJhbnNmZXItRW5jb2Rpbmc6IHF1b3RlZC1wcmludGFibGUKQ29udGVudC1UeXBl
OiB0ZXh0L3BsYWluOwoJY2hhcnNldD11cy1hc2NpaQoKSGksCgpJJ20gbG9va2luZyBmb3Ig
c29tZSB0ZXN0ZXJzIGZvciBzb21lIGNoYW5nZXMvc2ltcGxpZmljYXRpb25zIEkgbWFkZSB0
byA9CnRoZSBkb2NrZXIgaW1hZ2UgYW5kIHNjcmlwdHMgdXNlZCBmb3IgZGF0YXRyYWNrZXIg
ZGV2ZWxvcG1lbnQgKGkuZS4sIHRoZSA9CnN0dWZmIHVuZGVyIGh0dHBzOi8vc3ZuLmlldGYu
b3JnL3N2bi90b29scy9pZXRmZGIvdHJ1bmsvZG9ja2VyLykKClBsZWFzZSBkcm9wIG1lIGEg
bGluZSBpZiB5b3UnZCBoYXZlIGN5Y2xlcyB0byB0ZXN0IHNvbWUgdGhpbmdzLgoKVGhhbmtz
LApMYXJzCgoKLS1BcHBsZS1NYWlsPV9CRDUxQkJCNS1BMzY1LTQ4QUMtQjNDRC05NEYyNzUx
RjFBRTIKQ29udGVudC1UcmFuc2Zlci1FbmNvZGluZzogN2JpdApDb250ZW50LURpc3Bvc2l0
aW9uOiBhdHRhY2htZW50OwoJZmlsZW5hbWU9c2lnbmF0dXJlLmFzYwpDb250ZW50LVR5cGU6
IGFwcGxpY2F0aW9uL3BncC1zaWduYXR1cmU7CgluYW1lPXNpZ25hdHVyZS5hc2MKQ29udGVu
dC1EZXNjcmlwdGlvbjogTWVzc2FnZSBzaWduZWQgd2l0aCBPcGVuUEdQCgotLS0tLUJFR0lO
IFBHUCBTSUdOQVRVUkUtLS0tLQoKaVFJekJBRUJDZ0FkRmlFRW1wcTBacFNvZWpSbXloaGVW
TFhEQ2I5d3dWY0ZBbUZrRG1BQUNna1FWTFhEQ2I5dwp3VmREUnhBQWlUeEtUVHBSanVvVElH
VDJkR1JNTkJYTUVSY1lLL2piNXBhS0xrUmVPVTkvWmhPUnZseWt1VTFYCnA0ZXhlWDdvQXFU
dDVzUFowNitRV0lkZTk2Z2VKQ1diYUpWbUpKcEVUUUsxWkl1OStjWmNHMlNxTU5UWUdJSnIK
OVZ1WDFKbjJZblJ1Y3JJamJrK2hCdkg2bGkvRE9ib004TURQQ2hqSW9GbG5rRkQ3OCtuTGJC
emFIWVRURU5OQgo0TlJCRVk3VFRscUpFOFRBQWQwMG1aWmhDMUlzbmxhRG5Za0hCbVJXTCtu
NytXdmI0dlo1aW1HNTk5Q3l0Mm56ClI0YTdUZmtmbk9RMDF2WVNvelFubG4wazJURkdDUnlp
S1RpQnJaK05Jc3FPRTQ5R1pscWY0SWRZME1mK2pZVWIKZ3Jkd3BDMEpGV0JxeWRoQ1VNMnJC
RzR6Y002UE9YSDZiSkpXRE5maUZqaFpUeXFLcDJtb20yNzJ6KzYrTnJsSApUV1pPc292cGlZ
a2hSY2lmNlA4VmFEeCttRXV3RnBFRHRoTW03OTNBNnJaK2s5RDNzL3JUSjR4ODJOYXhXcGNj
CkltVGZ2QlB0dXVIUzZpUjdSNjZHY3JqcTdZMDJycDYvTmtPbGJ4V0liYmxlMDFwa25xTyts
amtqbkRIUE01U3IKekQvb1dseGhEcVBud3NrNitOY0xqS0dhWnl3ZGRZSWIxbWoxZHNGL2li
bkQvWFJFSTJQR2FZWjI4TW1VaGRhbApFdm0yUXI2UlhYSSt0cDZKMmpPWUt2TFc1cC90ME15
aXZZYUcvYnpwaUs3VVVDemRlanl2UjJSeDEwUTJHZlZvClVHbElnMkR3Vk9VOW14b25vVXJ6
QTVpRHNWWkVRRGgrbElVS05FNFNuSnE5NVN2L2ZmMD0KPUdzQmIKLS0tLS1FTkQgUEdQIFNJ
R05BVFVSRS0tLS0tCgotLUFwcGxlLU1haWw9X0JENTFCQkI1LUEzNjUtNDhBQy1CM0NELTk0
RjI3NTFGMUFFMi0tCgoK
--------------pYDFM8b0ODpyryQoJTuBwn3V
Content-Type: text/plain; charset=UTF-8; name="Attached Message Part"
Content-Disposition: attachment; filename="Attached Message Part"
Content-Transfer-Encoding: base64

X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX18KVG9vbHMtZGlzY3VzcyBtYWlsaW5nIGxpc3QgLSBUb29scy1kaXNjdXNzQGlldGYu
b3JnClRoaXMgbGlzdCBpcyBmb3IgZGlzY3Vzc2lvbiwgbm90IGZvciBhY3Rpb24gcmVxdWVz
dHMgb3IgYnVnIHJlcG9ydHMuCiogUmVwb3J0IGRhdGF0cmFja2VyIGFuZCBtYWlsYXJjaGl2
ZSBidWdzIHRvOiBkYXRhdHJhY2tlci1wcm9qZWN0QGlldGYub3JnCiogUmVwb3J0IHRvb2xz
LmlldGYub3JnIGJ1Z3MgdG86IHdlYm1hc3RlckB0b29scy5pZXRmLm9yZwoqIFJlcG9ydCBh
bGwgb3RoZXIgYnVncyBvciBpc3N1ZXMgdG86IGlldGYtYWN0aW9uQGlldGYub3JnCkxpc3Qg
aW5mbyAoaW5jbHVkaW5nIGhvdyB0byBVbnN1YnNjcmliZSk6IGh0dHBzOi8vd3d3LmlldGYu
b3JnL21haWxtYW4vbGlzdGluZm8vdG9vbHMtZGlzY3VzcwoK
--------------pYDFM8b0ODpyryQoJTuBwn3V--


From nobody Tue Oct 12 14:59:18 2021
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


From nobody Wed Oct 20 12:50:22 2021
Return-Path: <iesg-secretary@ietf.org>
X-Original-To: codesprints@ietf.org
Delivered-To: codesprints@ietfa.amsl.com
Received: from ietfa.amsl.com (localhost [IPv6:::1]) by ietfa.amsl.com (Postfix) with ESMTP id 9D3173A0DEC; Wed, 20 Oct 2021 12:50:03 -0700 (PDT)
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit
From: IESG Secretary <iesg-secretary@ietf.org>
To: "IETF-Announce" <ietf-announce@ietf.org>
Cc: tools-development@ietf.org, codesprints@ietf.org
X-Test-IDTracker: no
X-IETF-IDTracker: 7.39.0
Auto-Submitted: auto-generated
Precedence: bulk
Message-ID: <163475940345.8195.3821360655769443770@ietfa.amsl.com>
Date: Wed, 20 Oct 2021 12:50:03 -0700
Archived-At: <https://mailarchive.ietf.org/arch/msg/codesprints/ZhMslrvlFbwCyZlj5fTKrVTWRss>
Subject: [codesprints] The Tools Team (tools) TEAM Virtual Meeting: 2021-10-27
X-BeenThere: codesprints@ietf.org
X-Mailman-Version: 2.1.29
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: Wed, 20 Oct 2021 19:50:04 -0000

The The Tools Team (tools) Team will hold
a virtual interim meeting on 2021-10-27 from 11:00 to 15:00 America/Chicago (16:00 to 20:00 UTC).

Agenda:
Performance oriented Code Sprint Day 1

Locations:
Day 1: https://meetings.conf.meetecho.com/interim/?short=2bdb0bf8-6ac7-4211-b808-b1a430c515b2
Day 2: https://meetings.conf.meetecho.com/interim/?short=174b6e06-74be-4342-9d02-958d6f545d81

Information about remote participation:
https://meetings.conf.meetecho.com/interim/?short=2bdb0bf8-6ac7-4211-b808-b1a430c515b2


From nobody Wed Oct 20 12:51:14 2021
Return-Path: <iesg-secretary@ietf.org>
X-Original-To: codesprints@ietf.org
Delivered-To: codesprints@ietfa.amsl.com
Received: from ietfa.amsl.com (localhost [IPv6:::1]) by ietfa.amsl.com (Postfix) with ESMTP id CEE0E3A0E8A; Wed, 20 Oct 2021 12:50:56 -0700 (PDT)
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit
From: IESG Secretary <iesg-secretary@ietf.org>
To: "IETF-Announce" <ietf-announce@ietf.org>
Cc: tools-development@ietf.org, codesprints@ietf.org
X-Test-IDTracker: no
X-IETF-IDTracker: 7.39.0
Auto-Submitted: auto-generated
Precedence: bulk
Message-ID: <163475945680.22684.15006851056492112792@ietfa.amsl.com>
Date: Wed, 20 Oct 2021 12:50:56 -0700
Archived-At: <https://mailarchive.ietf.org/arch/msg/codesprints/Em2RV1jTpe8k0VyG_QzZi8RpfPQ>
Subject: [codesprints] The Tools Team (tools) TEAM Virtual Meeting: 2021-10-28
X-BeenThere: codesprints@ietf.org
X-Mailman-Version: 2.1.29
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: Wed, 20 Oct 2021 19:51:06 -0000

The The Tools Team (tools) Team will hold
a virtual interim meeting on 2021-10-28 from 11:00 to 15:00 America/Chicago (16:00 to 20:00 UTC).

Agenda:
Performance Code Sprint Day 2
Location:
Day 1: https://meetings.conf.meetecho.com/interim/?short=2bdb0bf8-6ac7-4211-b808-b1a430c515b2
Day 2:  https://meetings.conf.meetecho.com/interim/?short=174b6e06-74be-4342-9d02-958d6f545d81

Information about remote participation:
https://meetings.conf.meetecho.com/interim/?short=174b6e06-74be-4342-9d02-958d6f545d81


From nobody Wed Oct 20 15:42:38 2021
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 979CC3A0A21 for <codesprints@ietfa.amsl.com>; Wed, 20 Oct 2021 15:42:34 -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, HTML_MESSAGE=0.001, T_SPF_HELO_PERMERROR=0.01, T_SPF_PERMERROR=0.01] 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 K2q52cMzd4Dh for <codesprints@ietfa.amsl.com>; Wed, 20 Oct 2021 15:42:29 -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 B41BE3A0A10 for <codesprints@ietf.org>; Wed, 20 Oct 2021 15:42:29 -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 19KMgOWR001205 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NO) for <codesprints@ietf.org>; Wed, 20 Oct 2021 17:42:25 -0500 (CDT) (envelope-from rjsparks@nostrum.com)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=nostrum.com; s=default; t=1634769745; bh=Y/FIdPsm3kR/0zQdlYt+QwhFaTEt4rsue1g0H9ncFlE=; h=Date:Subject:References:To:From:In-Reply-To; b=GtSgu/CGgwq/FVloarIBfrtJu0/M8o5UDKO8UMC5jklcLHPsiICYqVR7Fq5jyc20/ nSjvQJtVfLjR8fmhHvNj1xF46RTYKZDip7PU5TEKIxis/FT87yH6sXbLEmmPP6qZCK IUGLvUI3ab76T3Z+/zI3eLslgEPuzPqmYzrAP4wQ=
X-Authentication-Warning: raven.nostrum.com: Host [47.186.34.206] claimed to be [192.168.1.114]
Content-Type: multipart/alternative; boundary="------------3nPC4fhO3dJMiUUZt4ziUtsS"
Message-ID: <afe526ba-0d9b-aa7e-53e1-e3f347c3eb27@nostrum.com>
Date: Wed, 20 Oct 2021 17:42:18 -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
References: <163475940345.8195.3821360655769443770@ietfa.amsl.com>
Content-Language: en-US
To: IETF Codesprints <codesprints@ietf.org>
From: Robert Sparks <rjsparks@nostrum.com>
In-Reply-To: <163475940345.8195.3821360655769443770@ietfa.amsl.com>
X-Forwarded-Message-Id: <163475940345.8195.3821360655769443770@ietfa.amsl.com>
Archived-At: <https://mailarchive.ietf.org/arch/msg/codesprints/4LESrH0SufXkwo8k67JhifSOWAA>
Subject: [codesprints] Fwd: [TOOLS-DEVELOPMENT] The Tools Team (tools) TEAM Virtual Meeting: 2021-10-27
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: Wed, 20 Oct 2021 22:42:35 -0000

This is a multi-part message in MIME format.
--------------3nPC4fhO3dJMiUUZt4ziUtsS
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

If you're planning to participate, please add yourself (I added the 
people who participated in the doodle) here:

https://notes.ietf.org/notes-ietf-interim-2021-tools-01-tools#

This is the notes page that will be linked from meetecho for the first 
day's session. It has a lot of information about the sprint already.

Let me know what else needs to be added.

RjS



-------- Forwarded Message --------
Subject: 	[TOOLS-DEVELOPMENT] The Tools Team (tools) TEAM Virtual 
Meeting: 2021-10-27
Date: 	Wed, 20 Oct 2021 12:50:03 -0700
From: 	IESG Secretary <iesg-secretary@ietf.org>
To: 	IETF-Announce <ietf-announce@ietf.org>
CC: 	tools-development@ietf.org, codesprints@ietf.org



The The Tools Team (tools) Team will hold
a virtual interim meeting on 2021-10-27 from 11:00 to 15:00 
America/Chicago (16:00 to 20:00 UTC).

Agenda:
Performance oriented Code Sprint Day 1

Locations:
Day 1: 
https://meetings.conf.meetecho.com/interim/?short=2bdb0bf8-6ac7-4211-b808-b1a430c515b2
Day 2: 
https://meetings.conf.meetecho.com/interim/?short=174b6e06-74be-4342-9d02-958d6f545d81

Information about remote participation:
https://meetings.conf.meetecho.com/interim/?short=2bdb0bf8-6ac7-4211-b808-b1a430c515b2

_______________________________________________
TOOLS-DEVELOPMENT mailing list
TOOLS-DEVELOPMENT@ietf.org
https://www.ietf.org/mailman/listinfo/tools-development
--------------3nPC4fhO3dJMiUUZt4ziUtsS
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>If you're planning to participate, please add yourself (I added
      the people who participated in the doodle) here:</p>
    <p><a class="moz-txt-link-freetext" href="https://notes.ietf.org/notes-ietf-interim-2021-tools-01-tools#">https://notes.ietf.org/notes-ietf-interim-2021-tools-01-tools#</a></p>
    <p>This is the notes page that will be linked from meetecho for the
      first day's session. It has a lot of information about the sprint
      already. <br>
    </p>
    <p>Let me know what else needs to be added.</p>
    <p>RjS<br>
    </p>
    <div class="moz-forward-container"><br>
      <br>
      -------- Forwarded Message --------
      <table class="moz-email-headers-table" cellspacing="0"
        cellpadding="0" border="0">
        <tbody>
          <tr>
            <th valign="BASELINE" nowrap="nowrap" align="RIGHT">Subject:
            </th>
            <td>[TOOLS-DEVELOPMENT] The Tools Team (tools) TEAM Virtual
              Meeting: 2021-10-27</td>
          </tr>
          <tr>
            <th valign="BASELINE" nowrap="nowrap" align="RIGHT">Date: </th>
            <td>Wed, 20 Oct 2021 12:50:03 -0700</td>
          </tr>
          <tr>
            <th valign="BASELINE" nowrap="nowrap" align="RIGHT">From: </th>
            <td>IESG Secretary <a class="moz-txt-link-rfc2396E" href="mailto:iesg-secretary@ietf.org">&lt;iesg-secretary@ietf.org&gt;</a></td>
          </tr>
          <tr>
            <th valign="BASELINE" nowrap="nowrap" align="RIGHT">To: </th>
            <td>IETF-Announce <a class="moz-txt-link-rfc2396E" href="mailto:ietf-announce@ietf.org">&lt;ietf-announce@ietf.org&gt;</a></td>
          </tr>
          <tr>
            <th valign="BASELINE" nowrap="nowrap" align="RIGHT">CC: </th>
            <td><a class="moz-txt-link-abbreviated" href="mailto:tools-development@ietf.org">tools-development@ietf.org</a>, <a class="moz-txt-link-abbreviated" href="mailto:codesprints@ietf.org">codesprints@ietf.org</a></td>
          </tr>
        </tbody>
      </table>
      <br>
      <br>
      The The Tools Team (tools) Team will hold<br>
      a virtual interim meeting on 2021-10-27 from 11:00 to 15:00
      America/Chicago (16:00 to 20:00 UTC).<br>
      <br>
      Agenda:<br>
      Performance oriented Code Sprint Day 1<br>
      <br>
      Locations:<br>
      Day 1:
<a class="moz-txt-link-freetext" href="https://meetings.conf.meetecho.com/interim/?short=2bdb0bf8-6ac7-4211-b808-b1a430c515b2">https://meetings.conf.meetecho.com/interim/?short=2bdb0bf8-6ac7-4211-b808-b1a430c515b2</a><br>
      Day 2:
<a class="moz-txt-link-freetext" href="https://meetings.conf.meetecho.com/interim/?short=174b6e06-74be-4342-9d02-958d6f545d81">https://meetings.conf.meetecho.com/interim/?short=174b6e06-74be-4342-9d02-958d6f545d81</a><br>
      <br>
      Information about remote participation:<br>
<a class="moz-txt-link-freetext" href="https://meetings.conf.meetecho.com/interim/?short=2bdb0bf8-6ac7-4211-b808-b1a430c515b2">https://meetings.conf.meetecho.com/interim/?short=2bdb0bf8-6ac7-4211-b808-b1a430c515b2</a><br>
      <br>
      _______________________________________________<br>
      TOOLS-DEVELOPMENT mailing list<br>
      <a class="moz-txt-link-abbreviated" href="mailto:TOOLS-DEVELOPMENT@ietf.org">TOOLS-DEVELOPMENT@ietf.org</a><br>
      <a class="moz-txt-link-freetext" href="https://www.ietf.org/mailman/listinfo/tools-development">https://www.ietf.org/mailman/listinfo/tools-development</a><br>
    </div>
  </body>
</html>
--------------3nPC4fhO3dJMiUUZt4ziUtsS--

