Re: worse than expected compression ratios with -o compress

2010-01-18 Thread Josef Bacik
On Sat, Jan 16, 2010 at 11:16:50AM -0500, Jim Faulkner wrote: I have a mysql database which consists of hundreds of millions, if not billions of Usenet newsgroup headers. This data should be highly compressable, so I put the mysql data directory on a btrfs filesystem mounted with the

Re: worse than expected compression ratios with -o compress

2010-01-18 Thread Jim Faulkner
On Sun, 17 Jan 2010, Sander wrote: A fair comparison would be to compress the actual database files. You are absolutely right. I've run some more tests, this time against the database files themselves. This time there are 73 GB worth of database files: delta-9 mysql # du -h 747K

Re: worse than expected compression ratios with -o compress

2010-01-18 Thread Jim Faulkner
On Mon, 18 Jan 2010, Jim Faulkner wrote: So, in summary, the compression ratios are: btrfs: 96% zip/gzip: 15% bzip2: 11% 7z: 8% NTFS: 41% One minor follow up. I used mysql mysqldump.sql to initially populate the database on the btrfs filesystem. I thought that this may affect the

Re: tests/misc/ls-time

2010-01-18 Thread Josef Bacik
On Sun, Jan 17, 2010 at 04:08:16PM +0100, Jim Meyering wrote: Michael Stone wrote: It seems that touch -a does update ctime on btrfs, invalidating one of the assumptions behind this test and causing it to fail. s/does/does not/ Thanks for the report. I've just confirmed this test

Maxim Sine amarE Kneshuk si Vás přidal do př� �tel na stránce VK.com

2010-01-18 Thread VK
Dobrý den, Maxim Sine amarE Kneshuk si Vás přidal do přátel na stránce VK.com Pomocí své e-mailové adresy a automaticky vytvořeného hesla: Mkxzg1sd, můžete zajít na stránku a prohlédnout si profily Vašich přátel. VK.com je stránka, která každý den umožňuje desítkám milionů lidí najít staré

Maxim Sine amarE Kneshuk si Vás přidal do př� �tel na stránce VK.com

2010-01-18 Thread VK
Dobrý den, Maxim Sine amarE Kneshuk si Vás přidal do přátel na stránce VK.com Pomocí své e-mailové adresy a automaticky vytvořeného hesla: ddVjDjqR, můžete zajít na stránku a prohlédnout si profily Vašich přátel. VK.com je stránka, která každý den umožňuje desítkám milionů lidí najít staré

btrfs write behavior on idle system

2010-01-18 Thread Carlos R. Mafra
Hi everyone, I am using btrfs for my /home partition since I upgraded my slow laptop hdd for an ssd 3 weeks ago. I am always in sync with Linus' tree of the day (plus a btrfs patch which is not in there yet) and so far I haven't lost any data, so all is good. I have a question about the write

Re: btrfs write behavior on idle system

2010-01-18 Thread Carlos R. Mafra
PS: On Mo 18.Jan'10 at 18:17:56 +0100, Carlos R. Mafra wrote: ... [ I get really worried when I 'blktrace -a write' my /home when actively using chrome. Just a 2-minute experiment here while I was writing this email ended up like this: ... blktrace (4226) Reads Queued: 0,

Re: btrfs write behavior on idle system

2010-01-18 Thread Ravi Pinjala
On 01/18/10 11:17, Carlos R. Mafra wrote: Hi everyone, I am using btrfs for my /home partition since I upgraded my slow laptop hdd for an ssd 3 weeks ago. I am always in sync with Linus' tree of the day (plus a btrfs patch which is not in there yet) and so far I haven't lost any data, so all is

Re: btrfs write behavior on idle system

2010-01-18 Thread Carlos R. Mafra
On Mo 18.Jan'10 at 12:14:43 -0600, Ravi Pinjala wrote: On 01/18/10 11:17, Carlos R. Mafra wrote: Hi everyone, I am using btrfs for my /home partition since I upgraded my slow laptop hdd for an ssd 3 weeks ago. I am always in sync with Linus' tree of the day (plus a btrfs patch which is not

Re: worse than expected compression ratios with -o compress

2010-01-18 Thread Chris Mason
On Mon, Jan 18, 2010 at 09:12:40AM -0500, Josef Bacik wrote: On Sat, Jan 16, 2010 at 11:16:50AM -0500, Jim Faulkner wrote: I have a mysql database which consists of hundreds of millions, if not billions of Usenet newsgroup headers. This data should be highly compressable, so I put

Re: worse than expected compression ratios with -o compress

2010-01-18 Thread Jim Faulkner
On Mon, 18 Jan 2010, Chris Mason wrote: Currently the only compression algorithm we support is gzip, so try gzipp'ing your database to get a better comparison. The plan is to eventually support other compression algorithms, but currently we do not. Thanks, The compression code backs off

Inconsistent reports after disk-error.

2010-01-18 Thread Ronny H. Kavli
I've been running btrfs on some disks with Ubuntu kernel 2.6.31 for a while now. Recently I had a bad USB-cable to one of those disks which left the btrfs filesystem in a somewhat sad state. Fair enough. What worries me is what btrfsck reports back to me during two successive runs:

Maxim Sine amarE Kneshuk si Vás přidal do př� �tel na stránce VK.com

2010-01-18 Thread VK
Dobrý den, Maxim Sine amarE Kneshuk si Vás přidal do přátel na stránce VK.com Pomocí své e-mailové adresy a automaticky vytvořeného hesla: cO0DmGLy, můžete zajít na stránku a prohlédnout si profily Vašich přátel. VK.com je stránka, která každý den umožňuje desítkám milionů lidí najít staré

Re: Inconsistent reports after disk-error.

2010-01-18 Thread Ronny H. Kavli
Ah. I can reply to myself after checking the logs when I try to mount with dmesg(1). Two successive mount-attempts give indeed a consistent result: [ 3712.163040] device fsid 794be0222f8f0708-ffaf918752666783 devid 1 transid 9044 /dev/mapper/vg3-vbox1 [ 3712.172059] btrfs: dm-7 checksum verify

btrfs system roll back is 80% done for Fedora 13

2010-01-18 Thread Martin Jeppesen
Chris Ball and Josef Bacik have just updated their work on system rollback with btrfs in Fedora 13. * Targeted release: Fedora 13 * Last updated: 2010-01-15 * Percentage of completion: 80% * Kernel patches for listing subvols and setting default subvolumes are submitted to