Re: Example of BTRFS uglyssima performance : Bitcoin

2012-12-04 Thread Sander
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 majord...@vger.kernel.org
More majordomo info at  http://vger.kernel.org/majordomo-info.html


Re: Example of BTRFS uglyssima performance : Bitcoin

2012-12-03 Thread Hugo Mills
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! ---   


signature.asc
Description: Digital signature


Re: Example of BTRFS uglyssima performance : Bitcoin

2012-12-03 Thread Swâmi Petaramesh
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 sw...@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 majord...@vger.kernel.org
More majordomo info at  http://vger.kernel.org/majordomo-info.html


Re: Example of BTRFS uglyssima performance : Bitcoin

2012-12-03 Thread Jan Schmidt
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 majord...@vger.kernel.org
More majordomo info at  http://vger.kernel.org/majordomo-info.html


Re: Example of BTRFS uglyssima performance : Bitcoin

2012-12-03 Thread Swâmi Petaramesh
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 sw...@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 majord...@vger.kernel.org
More majordomo info at  http://vger.kernel.org/majordomo-info.html


Re: Example of BTRFS uglyssima performance : Bitcoin

2012-12-03 Thread Wade Cline

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 majord...@vger.kernel.org
More majordomo info at  http://vger.kernel.org/majordomo-info.html


Re: Example of BTRFS uglyssima performance : Bitcoin

2012-12-03 Thread Chris Samuel
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 majord...@vger.kernel.org
More majordomo info at  http://vger.kernel.org/majordomo-info.html


Re: Example of BTRFS uglyssima performance : Bitcoin

2012-12-03 Thread Swâmi Petaramesh
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 sw...@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 majord...@vger.kernel.org
More majordomo info at  http://vger.kernel.org/majordomo-info.html