* [PATCH 1/3] over: skip nodatacow on the journal
2020-08-25 3:02 5% [PATCH 0/3] SQLite-related things Eric Wong
@ 2020-08-25 3:02 7% ` Eric Wong
0 siblings, 0 replies; 2+ results
From: Eric Wong @ 2020-08-25 3:02 UTC (permalink / raw)
To: meta
This file gets truncated anyhow, so it won't fragment.
---
lib/PublicInbox/Over.pm | 3 ---
1 file changed, 3 deletions(-)
diff --git a/lib/PublicInbox/Over.pm b/lib/PublicInbox/Over.pm
index fba58d17..a2f04117 100644
--- a/lib/PublicInbox/Over.pm
+++ b/lib/PublicInbox/Over.pm
@@ -21,9 +21,6 @@ sub dbh_new {
require PublicInbox::Spawn;
open my $fh, '+>>', $f or die "failed to open $f: $!";
PublicInbox::Spawn::nodatacow_fd(fileno($fh));
- my $j = "$f-journal";
- open $fh, '+>>', $j or die "failed to open $j: $!";
- PublicInbox::Spawn::nodatacow_fd(fileno($fh));
} else {
$self->{filename} = $f; # die on stat() below:
}
^ permalink raw reply related [relevance 7%]
* [PATCH 0/3] SQLite-related things
@ 2020-08-25 3:02 5% Eric Wong
2020-08-25 3:02 7% ` [PATCH 1/3] over: skip nodatacow on the journal Eric Wong
0 siblings, 1 reply; 2+ results
From: Eric Wong @ 2020-08-25 3:02 UTC (permalink / raw)
To: meta
While I'm considering options for dealing with SQLite locking
problems <https://public-inbox.org/meta/20200825001204.GA840@dcvr/>,
some obvious cleanups and improvements can be made, here.
We'll now support WAL if (and only if) a user chooses to enable
it; since we can't do it by default (see 3/3 for explanation).
Eric Wong (3):
over: skip nodatacow on the journal
msgmap: use "CREATE TABLE IF NOT EXISTS"
over+msgmap: respect WAL journal_mode if set
lib/PublicInbox/Msgmap.pm | 29 ++++++++++++++---------------
lib/PublicInbox/Over.pm | 26 ++++++++++++++++++++++----
lib/PublicInbox/OverIdx.pm | 5 -----
t/over.t | 10 ++++++++++
4 files changed, 46 insertions(+), 24 deletions(-)
^ permalink raw reply [relevance 5%]
Results 1-2 of 2 | reverse | options above
-- pct% links below jump to the message on this page, permalinks otherwise --
2020-08-25 3:02 5% [PATCH 0/3] SQLite-related things Eric Wong
2020-08-25 3:02 7% ` [PATCH 1/3] over: skip nodatacow on the journal Eric Wong
Code repositories for project(s) associated with this public inbox
https://80x24.org/public-inbox.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).