1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
|
Return-Path: <j@blockstream.io>
Received: from smtp1.linuxfoundation.org (smtp1.linux-foundation.org
[172.17.192.35])
by mail.linuxfoundation.org (Postfix) with ESMTPS id E55916C
for <bitcoin-dev@lists.linuxfoundation.org>;
Wed, 18 Nov 2015 00:07:15 +0000 (UTC)
X-Greylist: whitelisted by SQLgrey-1.7.6
Received: from mail-yk0-f172.google.com (mail-yk0-f172.google.com
[209.85.160.172])
by smtp1.linuxfoundation.org (Postfix) with ESMTPS id 1BD0C13A
for <bitcoin-dev@lists.linuxfoundation.org>;
Wed, 18 Nov 2015 00:07:15 +0000 (UTC)
Received: by ykfs79 with SMTP id s79so36961350ykf.1
for <bitcoin-dev@lists.linuxfoundation.org>;
Tue, 17 Nov 2015 16:07:14 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=blockstream_com.20150623.gappssmtp.com; s=20150623;
h=mime-version:in-reply-to:references:from:date:message-id:subject:to
:cc:content-type;
bh=Bud4T526+uUK2+P73azbRVIg3Zu8wUXNkicCm+J3LZo=;
b=nH80s5T1g3TIeb+LJHKxWeHYusEeBUdGEBNsCTN7PufQRs/ZVxHln8/OW50JHpqjSP
jd7GFGOf3YUC4eG/vJbGGySghUlmBLEw6ufPNAIU/9FhQtS/zJSbprYat0GMIejDmgXc
6kvjVOpJwDUXiz5SiVdH+pzMEvHLP37sTBMMuPek5H2d7KFkJo4jm8442PWYjj8KkF2J
/68kL2vLk5arJXVpE001pQWqPu31fd08PRJSDbJaMSAoiIXzvxERP3Fcoh1LRKxGSJKp
+RGpFzZsKm11liGPOH3ImlzIcEo/oKHbCbNJkvNoMLx0zfXC6guhtnCeK17cJv+Q4rjH
pE4A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=1e100.net; s=20130820;
h=x-gm-message-state:mime-version:in-reply-to:references:from:date
:message-id:subject:to:cc:content-type;
bh=Bud4T526+uUK2+P73azbRVIg3Zu8wUXNkicCm+J3LZo=;
b=X08+kdz/ghbZBM4fTTGZ1ed8IVeHAg50+fXrYZ64WY1e1AT2dcdGWPkHDREJJ62pbK
R8JNylBGAy8zWnDo82Hbqrg6d17c500HEL2JQF7VPCvJSmFUcQ3SMQEXUWPPAZ94zfff
Cc0iV+tS7JzBJVq8XgOZECMNDt+njlMn/mPRFCwrv2bIVd1vEABYuYrnF1f7XxPfMrSP
6Gyf+rPJuxdPQj3VodJRaB47JjreybVq+bWkaS9ZZWQOqxq+Xjys2q8oGrhi8oRZkWzL
sCHLhSrCHDkIoRFev6Ph1F97AePCulhd0og2MUAPDBqX9WXc+sh2lE4ntWDB789TS7c2
+MDA==
X-Gm-Message-State: ALoCoQlWqsdLbAMuIfzQef2boRlXHXFlbwZmx1Sxd1WkvUp11q/4DSnd8+bhcyhYIJfVZT+wACg/
X-Received: by 10.129.159.5 with SMTP id w5mr3663515ywg.57.1447805234244; Tue,
17 Nov 2015 16:07:14 -0800 (PST)
MIME-Version: 1.0
Received: by 10.31.3.193 with HTTP; Tue, 17 Nov 2015 16:06:44 -0800 (PST)
In-Reply-To: <562E6BC0.7010002@vt.edu>
References: <CADm_WcaLQzigsdmFR43JqiCYJVpmqkhVDc8GiVG=UN+Z1zg7+w@mail.gmail.com>
<3162730.lzR74nC3xW@garp> <562E6BC0.7010002@vt.edu>
From: Jonathan Wilkins <j@blockstream.com>
Date: Tue, 17 Nov 2015 16:06:44 -0800
Message-ID: <CAL0tybca59rZ6KiyqY8iUFpH94Zw0T1o16OZ-uO0YYjRCo7vFw@mail.gmail.com>
To: Douglas Roark <joroark@vt.edu>
Content-Type: multipart/alternative; boundary=94eb2c0bd6a4b13e7d0524c56c7b
X-Spam-Status: No, score=-2.6 required=5.0 tests=BAYES_00,DKIM_SIGNED,
DKIM_VALID,HTML_MESSAGE,RCVD_IN_DNSWL_LOW autolearn=ham version=3.3.1
X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on
smtp1.linux-foundation.org
X-Mailman-Approved-At: Wed, 18 Nov 2015 00:07:58 +0000
Cc: bitcoin-dev@lists.linuxfoundation.org
Subject: Re: [bitcoin-dev] [patch] Switching Bitcoin Core to sqlite db
X-BeenThere: bitcoin-dev@lists.linuxfoundation.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: Bitcoin Development Discussion <bitcoin-dev.lists.linuxfoundation.org>
List-Unsubscribe: <https://lists.linuxfoundation.org/mailman/options/bitcoin-dev>,
<mailto:bitcoin-dev-request@lists.linuxfoundation.org?subject=unsubscribe>
List-Archive: <http://lists.linuxfoundation.org/pipermail/bitcoin-dev/>
List-Post: <mailto:bitcoin-dev@lists.linuxfoundation.org>
List-Help: <mailto:bitcoin-dev-request@lists.linuxfoundation.org?subject=help>
List-Subscribe: <https://lists.linuxfoundation.org/mailman/listinfo/bitcoin-dev>,
<mailto:bitcoin-dev-request@lists.linuxfoundation.org?subject=subscribe>
X-List-Received-Date: Wed, 18 Nov 2015 00:07:16 -0000
--94eb2c0bd6a4b13e7d0524c56c7b
Content-Type: text/plain; charset=UTF-8
Benchmarks for various DBs under discussion:
http://symas.com/mdb/microbench/
On Mon, Oct 26, 2015 at 11:06 AM, Douglas Roark via bitcoin-dev <
bitcoin-dev@lists.linuxfoundation.org> wrote:
> On 2015/10/23 03:30, Tom Zander via bitcoin-dev wrote:
> > On Thursday 22 Oct 2015 17:26:42 Jeff Garzik via bitcoin-dev wrote:
> >> It was noted that leveldb is unmaintained, and this is part of
> researching
> >> alternatives that are maintained and reliable.
> >
> > Apart from it being unmaintained, any links to what are problems with
> levelDB?
>
> While not exactly the most rigorous link,
> https://en.wikipedia.org/wiki/LevelDB#Bugs_and_Reliability seems like an
> okay place to start. One thing I can attest to is that, when Armory used
> LevelDB (0.8 - 0.92, IIRC), quite a few users had DB corruption issues,
> particularly on Windows. Even when a switch to LMDB occurred for 0.93,
> loads of complaints would come in from users whose LevelDB-based Core
> DBs would fail. I know that the guy who moved Armory over to LMDB would
> love to have more time in the day so that he could write a Core patch
> that does the same. It's a very sore spot for him.
>
> (FWIW, LMDB seems to work quite nicely, at least once you patch up the
> source a little bit. The latest version is also compatible with Core's
> cross-compiling scheme. I'd love to see it added to Core one day.)
>
> Doug
> _______________________________________________
> bitcoin-dev mailing list
> bitcoin-dev@lists.linuxfoundation.org
> https://lists.linuxfoundation.org/mailman/listinfo/bitcoin-dev
>
--94eb2c0bd6a4b13e7d0524c56c7b
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr">Benchmarks for various DBs under discussion:<br><a href=3D=
"http://symas.com/mdb/microbench/">http://symas.com/mdb/microbench/</a><br>=
<br></div><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">On Mon,=
Oct 26, 2015 at 11:06 AM, Douglas Roark via bitcoin-dev <span dir=3D"ltr">=
<<a href=3D"mailto:bitcoin-dev@lists.linuxfoundation.org" target=3D"_bla=
nk">bitcoin-dev@lists.linuxfoundation.org</a>></span> wrote:<br><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc s=
olid;padding-left:1ex"><span class=3D"">On 2015/10/23 03:30, Tom Zander via=
bitcoin-dev wrote:<br>
> On Thursday 22 Oct 2015 17:26:42 Jeff Garzik via bitcoin-dev wrote:<br=
>
>> It was noted that leveldb is unmaintained, and this is part of res=
earching<br>
>> alternatives that are maintained and reliable.<br>
><br>
> Apart from it being unmaintained, any links to what are problems with =
levelDB?<br>
<br>
</span>While not exactly the most rigorous link,<br>
<a href=3D"https://en.wikipedia.org/wiki/LevelDB#Bugs_and_Reliability" rel=
=3D"noreferrer" target=3D"_blank">https://en.wikipedia.org/wiki/LevelDB#Bug=
s_and_Reliability</a> seems like an<br>
okay place to start. One thing I can attest to is that, when Armory used<br=
>
LevelDB (0.8 - 0.92, IIRC), quite a few users had DB corruption issues,<br>
particularly on Windows. Even when a switch to LMDB occurred for 0.93,<br>
loads of complaints would come in from users whose LevelDB-based Core<br>
DBs would fail. I know that the guy who moved Armory over to LMDB would<br>
love to have more time in the day so that he could write a Core patch<br>
that does the same. It's a very sore spot for him.<br>
<br>
(FWIW, LMDB seems to work quite nicely, at least once you patch up the<br>
source a little bit. The latest version is also compatible with Core's<=
br>
cross-compiling scheme. I'd love to see it added to Core one day.)<br>
<br>
Doug<br>
<div class=3D"HOEnZb"><div class=3D"h5">___________________________________=
____________<br>
bitcoin-dev mailing list<br>
<a href=3D"mailto:bitcoin-dev@lists.linuxfoundation.org">bitcoin-dev@lists.=
linuxfoundation.org</a><br>
<a href=3D"https://lists.linuxfoundation.org/mailman/listinfo/bitcoin-dev" =
rel=3D"noreferrer" target=3D"_blank">https://lists.linuxfoundation.org/mail=
man/listinfo/bitcoin-dev</a><br>
</div></div></blockquote></div><br></div>
--94eb2c0bd6a4b13e7d0524c56c7b--
|