From mboxrd@z Thu Jan 1 00:00:00 1970 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--