Hi folks, My laptop is a Core i3-2310M with 4 GB RAM, running BTRFS on a 1 TB HD. I run Ubuntu 12.10 Quantal, kernel 3.5.0-19-generic 64-bit. I wanted to give a shot at bitcoin so I installed it from the Ubuntu PPA, and started getting the database from the Internet. (it''s now 4.5 GB big on disk). I assume it an SQL DB (SQlite or so ?) My system currently has been crushing its data for more that 5 days now (5x24 hours) with the HD busy to the point that the system is completely unusable and I had to take another laptop to be able to surf the web and process my email. Disk LED is steadily lit, trying to switch between 2 open windows takes 5 minutes or so... Entering new blocks into the DB has now slowed down to the point that I assume that the last 6% that I miss (I''m now at 94.something %) may well take another couple weeks or so... Friends running ext4 told me that the initial loading of the DB took them a couple hours... With BTRFS it''s been 5x24 hours and counting... :-( This filesystem is pure crap as soon as it comes to database processing :-( Kind regards. -- Swâmi Petaramesh <swami@petaramesh.org> http://petaramesh.org PGP 9076E32E Ne cherchez pas : Je ne suis pas sur Facebook. -- To unsubscribe from this list: send the line "unsubscribe linux-btrfs" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html
On Mon, Dec 03, 2012 at 12:54:30PM +0100, Swâmi Petaramesh wrote:> Hi folks, > > My laptop is a Core i3-2310M with 4 GB RAM, running BTRFS on a 1 TB HD. > > I run Ubuntu 12.10 Quantal, kernel 3.5.0-19-generic 64-bit.Try 3.7. That''s had some significant performance improvements. 3.5 is over 6 months old, which is a long time in btrfs development.> I wanted to give a shot at bitcoin so I installed it from the Ubuntu > PPA, and started getting the database from the Internet. (it''s now 4.5 > GB big on disk). I assume it an SQL DB (SQlite or so ?)Try marking the SQLite database file(s) as nocow, with chattr +C. That also only works on 3.7, but should deal with your database problems.> My system currently has been crushing its data for more that 5 days now > (5x24 hours) with the HD busy to the point that the system is completely > unusable and I had to take another laptop to be able to surf the web and > process my email. Disk LED is steadily lit, trying to switch between 2 > open windows takes 5 minutes or so... > > Entering new blocks into the DB has now slowed down to the point that I > assume that the last 6% that I miss (I''m now at 94.something %) may well > take another couple weeks or so... > > Friends running ext4 told me that the initial loading of the DB took > them a couple hours... With BTRFS it''s been 5x24 hours and counting... :-( > > This filesystem is pure crap as soon as it comes to database processing :-(3.5 was. 3.7 shouldn''t be -- particularly with the use of +C on the database files. Hugo. -- === Hugo Mills: hugo@... carfax.org.uk | darksatanic.net | lug.org.uk == PGP key: 515C238D from wwwkeys.eu.pgp.net or http://www.carfax.org.uk --- "No! My collection of rare, incurable diseases! Violated!" ---
Swâmi Petaramesh
2012-Dec-03 12:24 UTC
Re: Example of BTRFS uglyssima performance : Bitcoin
Le 03/12/2012 13:09, Hugo Mills a écrit :> Try 3.7. That''s had some significant performance improvements. 3.5 is > over 6 months old, which is a long time in btrfs development.I understand the suggestion from a developper''s PoV, but from a user''s that''s much too much hassle living ahead of one''s distro''s kernel, or using "vanilla" ones. Been there, done that. No more suffering for me please ;-)) I''ll have to stick with current Ubuntu kernel, or at least with a future backport... Kind regards. -- Swâmi Petaramesh <swami@petaramesh.org> http://petaramesh.org PGP 9076E32E Ne cherchez pas : Je ne suis pas sur Facebook. -- To unsubscribe from this list: send the line "unsubscribe linux-btrfs" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html
Hi Swâmi, On Mon, December 03, 2012 at 12:54 (+0100), Swâmi Petaramesh wrote:> Hi folks, > > My laptop is a Core i3-2310M with 4 GB RAM, running BTRFS on a 1 TB HD. > > I run Ubuntu 12.10 Quantal, kernel 3.5.0-19-generic 64-bit. > > I wanted to give a shot at bitcoin so I installed it from the Ubuntu > PPA, and started getting the database from the Internet. (it''s now 4.5 > GB big on disk). I assume it an SQL DB (SQlite or so ?) > > My system currently has been crushing its data for more that 5 days now > (5x24 hours) with the HD busy to the point that the system is completely > unusable and I had to take another laptop to be able to surf the web and > process my email. Disk LED is steadily lit, trying to switch between 2 > open windows takes 5 minutes or so... > > Entering new blocks into the DB has now slowed down to the point that I > assume that the last 6% that I miss (I''m now at 94.something %) may well > take another couple weeks or so... > > Friends running ext4 told me that the initial loading of the DB took > them a couple hours... With BTRFS it''s been 5x24 hours and counting... :-(I''ve experienced exactly the same as you have with btrfs, only with ext4 instead of btrfs: Use ubuntu (which in the default setup means you''re using ecryptfs for your /home), install the bitcoin package (which puts its files in ~/.bitcoin) and the computer becomes very much unresponsive once bitcoin is fetching data blocks. Unresponsive here means that even the desktop clock misses to count a second here and then, the mouse pointer stops reacting. Haven''t looked further into this, but I suspect ecryptfs isn''t completely innocent in that stack. That said, I suggest trying to make an ext4 partition on the very same hardware, setup ecryptfs, mount it as ~/.bitcoin and share your findings :-) Besides that, as Hugo told you, you can disable btrfs cow on the database files, but given my experiences I wouldn''t put too much hope into that part. -Jan -- To unsubscribe from this list: send the line "unsubscribe linux-btrfs" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html
Swâmi Petaramesh
2012-Dec-03 16:58 UTC
Re: Example of BTRFS uglyssima performance : Bitcoin
Le 03/12/2012 16:55, Jan Schmidt a écrit :> Use ubuntu (which in the default setup means you''re using ecryptfs for > your /home),I actually do not use ecryptfs here, but OTOH I have BTRFS over LUKS/LVM. But I''ve been using pretty *anything over LUKS/LVM for years, and I''ve never notice it cause any (noticeable to the point of becoming annoying) system slowdown, whatever tasks I may have processed in such setups (including servers, big databases, compilations, NAS, etc...) So I doubt that the encryption is involved here... At least not very heavily involved. But I may ask my son if he volunteers to test the same on his unencrypted BTRFS netbook...> Besides that, as Hugo told you, you can disable btrfs cow on the database files, > but given my experiences I wouldn''t put too much hope into that part.As far as I understood, this option won''t work unless I have a 3.7+ kernel... BTW, what is the effect of "nocow" with respect to snapshots ? I would assume that then, snapshots contain the current data ? Kind regards. -- Swâmi Petaramesh <swami@petaramesh.org> http://petaramesh.org PGP 9076E32E Ne cherchez pas : Je ne suis pas sur Facebook. -- To unsubscribe from this list: send the line "unsubscribe linux-btrfs" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html
Hi Swâmi, On 12/03/2012 04:09 AM, Hugo Mills wrote:> On Mon, Dec 03, 2012 at 12:54:30PM +0100, Swâmi Petaramesh wrote: >> Hi folks, >> >> My laptop is a Core i3-2310M with 4 GB RAM, running BTRFS on a 1 TB HD. >> >> I run Ubuntu 12.10 Quantal, kernel 3.5.0-19-generic 64-bit. > > Try 3.7. That''s had some significant performance improvements. 3.5 > is over 6 months old, which is a long time in btrfs development.I''d like to emphasize this point. 3.7 has some _very_ significant performance improvements for database workloads; you will _need_ to run at least a 3.7 kernel to have an acceptable run speed for that type of workload (at least in my experience). Seriously. Also, the nodatacow option Hugo mentioned will also help. Regards, Wade -- To unsubscribe from this list: send the line "unsubscribe linux-btrfs" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html
Gregory Maxwell
2012-Dec-03 19:32 UTC
Re: Example of BTRFS uglyssima performance : Bitcoin
On Mon, Dec 3, 2012 at 6:54 AM, Swâmi Petaramesh <swami@petaramesh.org> wrote:> I assume it an SQL DB (SQlite or so ?)It''s BDB with a very pessimal random write workload updating transaction indexes with stuffed full of sync writes, interspersed with an equal amount of random reads. (The next version of the software will change the backend in several ways, including replacing BDB with leveldb and its orders of magnitude faster; but for now it''s probably a fine FS abusive test case) -- To unsubscribe from this list: send the line "unsubscribe linux-btrfs" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html
On 03/12/12 23:24, Swâmi Petaramesh wrote:> I understand the suggestion from a developper''s PoV, but from a > user''s that''s much too much hassle living ahead of one''s distro''s > kernel, or using "vanilla" ones. Been there, done that. No more > suffering for me please ;-)) > > I''ll have to stick with current Ubuntu kernel, or at least with a > future backport...In that case maybe using an experimental filesystem that is under rapid development might not be a good choice, it might be better to stick to one of the existing stable filesystems instead. Have you benchmarked your workload on other filesystems? cheers, Chris -- Chris Samuel : http://www.csamuel.org/ : Melbourne, VIC -- To unsubscribe from this list: send the line "unsubscribe linux-btrfs" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html
Swâmi Petaramesh
2012-Dec-04 07:22 UTC
Re: Example of BTRFS uglyssima performance : Bitcoin
Hi Chris, Le 04/12/2012 03:18, Chris Samuel a écrit :> In that case maybe using an experimental filesystem that is under rapid > development might not be a good choice, it might be better to stick to > one of the existing stable filesystems instead.I already made the move back and forth ext4 <-> BTRFS twice... Reading here or there that the new (or the next) kernel is the one that indeed fixes the bugs (3.3) or gives performance improvements (3.5), or will make you happy this time, etc... And each time I''m told that well, the current kernel is not so good actually, but the next one is so much better ! So you should try the next beta, or fetch and compile the curent mainline kernel... ...Neverending story... All this boils down to : I do really need some of the features of BTRFS (snapshots, checksumming, supposed high reliability...) but I also need my computers to stay usable on a daily basis without too much hassle and not spending 3 hours a day beta-testing or upgrading kernels... or waiting for my mouse click to produce a result. For getting this result I have a choice between : - ZFS, that has proven rock-solid, feature-rich and efficient on one of my machines for 2+ years, but is''nt part of "standard" Linux, will probably never be, so causes issues at each distro, is tricky installing as rootfs and which future in Linux is unclear (I don''t want to have to reinstall in 6 months a machine I install now because its filesystem would end being unsupported...) - BTRFS, which has already proven that it could kill all my data 3 times, which is badly slow, immature, but part of the standard kernel, and supposed to improve at a fast pace and have its future ahead. So basically each time I install a new system, I ask myself : ext4 ? (but I will lack features I badly need)... ZFS ? (Excellent today, but will I have to reinstall the machine in 6 months ?)... BTRFS (a slow unreliable pain in the a** today, but is it this time mature enough that this bet will make sense ?). So well... 3.5 is a pain for databases... Now I hope I will be happy in 6 months at next Ubuntu release... If not, maybe in a year... Or a couple years... Well... Kind regards. -- Swâmi Petaramesh <swami@petaramesh.org> http://petaramesh.org PGP 9076E32E Ne cherchez pas : Je ne suis pas sur Facebook. -- To unsubscribe from this list: send the line "unsubscribe linux-btrfs" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html
Swâmi Petaramesh wrote (ao):> But I''ve been using pretty *anything over LUKS/LVM for years, and I''ve > never notice it cause any (noticeable to the point of becoming annoying) > system slowdown, whatever tasks I may have processed in such setups > (including servers, big databases, compilations, NAS, etc...)If your system is stable, you could also consider running bitcoin with eatmydata. Sander -- To unsubscribe from this list: send the line "unsubscribe linux-btrfs" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html