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>
index | next in thread | previous in thread | raw e-mail
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).home | help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?BANLkTikHf%2B9wB_RM8A3Vq5-HD8mY9AMp8Q>