Date: Mon, 13 Jun 2011 11:29:06 +0200 From: =?UTF-8?Q?=C5=A0imun_Mikecin?= <numisemis@gmail.com> To: Steven Hartland <killing@multiplay.co.uk>, freebsd-fs@freebsd.org Subject: Re: Impossible compression ratio on ZFS Message-ID: <BANLkTikHf%2B9wB_RM8A3Vq5-HD8mY9AMp8Q@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
2011/6/13 Steven Hartland <killing@multiplay.co.uk> > 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 detail.frm > 7.5K detail.ibd > > ls -l detail* > -rw-rw---- 1 mysql mysql 8660 Jun 13 10:00 detail.frm > -rw-rw---- 1 mysql mysql 650117120 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? > It is possible if the file detail.ibd is mostly filled with zeros (that would be the case unless you have 620MB of real data).
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?BANLkTikHf%2B9wB_RM8A3Vq5-HD8mY9AMp8Q>