Date: Mon, 13 Jun 2011 17:48:54 +0700 From: Edho P Arief <edhoprima@gmail.com> To: Steven Hartland <killing@multiplay.co.uk> Cc: freebsd-fs@freebsd.org Subject: Re: Impossible compression ratio on ZFS Message-ID: <BANLkTimdgz%2B4yz7hnNL7iZp_jVZ02yfTSQ@mail.gmail.com> In-Reply-To: <F21D6DCDBA494B4A9FDF20A13BC4947A@multiplay.co.uk> References: <F21D6DCDBA494B4A9FDF20A13BC4947A@multiplay.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, Jun 13, 2011 at 4:13 PM, Steven Hartland <killing@multiplay.co.uk> wrote: > I've just done an optimisation of a mysql table which is located > on a compressed zfs partition and spotted that the size reported > by du is impossibly small for the file:- > > du -h detail* > 1.5K =C2=A0 =C2=A0detail.frm > 7.5K =C2=A0 =C2=A0detail.ibd > > ls -l detail* > -rw-rw---- =C2=A01 mysql =C2=A0mysql =C2=A0 =C2=A0 =C2=A0 8660 Jun 13 10:= 00 detail.frm > -rw-rw---- =C2=A01 mysql =C2=A0mysql =C2=A0650117120 Jun 13 10:04 detail.= ibd > > The table format for those interested is 3 int's, 3 indexes and > contains 8million rows. > > I highly doubt that my 620MB table is taking up just 7.5K on disk > any ideas? > you can try gzipping the file to verify this...
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?BANLkTimdgz%2B4yz7hnNL7iZp_jVZ02yfTSQ>