MIME-Version: 1.0
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
Cc: bitcoin-dev@lists.linuxfoundation.org
Subject: Re: [bitcoin-dev] [patch] Switching Bitcoin Core to sqlite db
Precedence: list

--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">=
&lt;<a href=3D"mailto:bitcoin-dev@lists.linuxfoundation.org" target=3D"_bla=
nk">bitcoin-dev@lists.linuxfoundation.org</a>&gt;</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>
&gt; On Thursday 22 Oct 2015 17:26:42 Jeff Garzik via bitcoin-dev wrote:<br=
>
&gt;&gt; It was noted that leveldb is unmaintained, and this is part of res=
earching<br>
&gt;&gt; alternatives that are maintained and reliable.<br>
&gt;<br>
&gt; 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&#39;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&#39;s<=
br>
cross-compiling scheme. I&#39;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--