From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on dcvr.yhbt.net X-Spam-Level: X-Spam-Status: No, score=-4.0 required=3.0 tests=ALL_TRUSTED,BAYES_00 shortcircuit=no autolearn=ham autolearn_force=no version=3.4.2 Received: from localhost (dcvr.yhbt.net [127.0.0.1]) by dcvr.yhbt.net (Postfix) with ESMTP id 01B121F5AE for ; Tue, 14 Jul 2020 02:14:32 +0000 (UTC) From: Eric Wong To: meta@public-inbox.org Subject: [PATCH 0/3] avoid msgmap reopens in long-lived processes Date: Tue, 14 Jul 2020 02:14:29 +0000 Message-Id: <20200714021432.11024-1-e@yhbt.net> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: As with commit 2a717d13f10fcdc69921d80cf94c47a694a175d4 ("nntpd+imapd: detect replaced over.sqlite3"), this is another step towards eliminating needless wakeups on systems with inotify or kqueue. To save memory, we'll also stop storing {filename} in Perl once the SQLite DB is open, since we expect to have thousands of inboxes soon. Eric Wong (3): over: unset sqlite_unicode attribute nntpd+imapd: detect unlinked msgmap over+msgmap: do not store filename after DBI->connect lib/PublicInbox/Inbox.pm | 11 +++---- lib/PublicInbox/Msgmap.pm | 67 ++++++++++++++++++++------------------ lib/PublicInbox/Over.pm | 31 +++++++++++++----- lib/PublicInbox/OverIdx.pm | 6 ++-- t/nntpd.t | 8 +++++ 5 files changed, 74 insertions(+), 49 deletions(-)