From owner-freebsd-fs@FreeBSD.ORG  Mon Jun 13 11:13:40 2011
Return-Path: <owner-freebsd-fs@FreeBSD.ORG>
Delivered-To: freebsd-fs@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 3DF1A106564A
	for <freebsd-fs@freebsd.org>; Mon, 13 Jun 2011 11:13:40 +0000 (UTC)
	(envelope-from edhoprima@gmail.com)
Received: from mail-bw0-f54.google.com (mail-bw0-f54.google.com
	[209.85.214.54])
	by mx1.freebsd.org (Postfix) with ESMTP id BF53F8FC13
	for <freebsd-fs@freebsd.org>; Mon, 13 Jun 2011 11:13:39 +0000 (UTC)
Received: by bwz12 with SMTP id 12so5332789bwz.13
	for <freebsd-fs@freebsd.org>; Mon, 13 Jun 2011 04:13:38 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:in-reply-to:references:from:date
	:message-id:subject:to:cc:content-type:content-transfer-encoding;
	bh=8z9MaYXYt+WxnTTG+UP4bYy9Zxyhch23Sme5sLWzeqY=;
	b=EulINdk4MjFNX9oXjtwZNuD8JeQjda+nVVaQFA3nSjEXds9ywn0WRKJYehUzXSi2/8
	5oAGY5XWaLpA0gV3ntQp2vfrYm0JSD9svYy4XL7pKT+SsdvNIm9V4CAMWcX8uyyDzSW/
	y7wz1iJJ6ZJs9Fn8i42YsyP8seebqMuna1ckw=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:from:date:message-id:subject:to
	:cc:content-type:content-transfer-encoding;
	b=CKPnz7SMwIV1JhbQC2R3mI07nfO7E6e+S8NdzaK5zOvvr7l8ZwF1v9e5bv6fDJTrKt
	iUz/KmMfRabfhUnDn7NX7ZhfJmoqdvmkcMh/DXIdTaPKtfdN3wqUhwKFw222IHSsuzbK
	yO5knHgjikSNEh9DlFibhybkDsxQOcBmJuLeI=
Received: by 10.204.74.67 with SMTP id t3mr149986bkj.43.1307962154120; Mon, 13
	Jun 2011 03:49:14 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.204.103.15 with HTTP; Mon, 13 Jun 2011 03:48:54 -0700 (PDT)
In-Reply-To: <F21D6DCDBA494B4A9FDF20A13BC4947A@multiplay.co.uk>
References: <F21D6DCDBA494B4A9FDF20A13BC4947A@multiplay.co.uk>
From: Edho P Arief <edhoprima@gmail.com>
Date: Mon, 13 Jun 2011 17:48:54 +0700
Message-ID: <BANLkTimdgz+4yz7hnNL7iZp_jVZ02yfTSQ@mail.gmail.com>
To: Steven Hartland <killing@multiplay.co.uk>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Cc: freebsd-fs@freebsd.org
Subject: Re: Impossible compression ratio on ZFS
X-BeenThere: freebsd-fs@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Filesystems <freebsd-fs.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-fs>,
	<mailto:freebsd-fs-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-fs>
List-Post: <mailto:freebsd-fs@freebsd.org>
List-Help: <mailto:freebsd-fs-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-fs>,
	<mailto:freebsd-fs-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 13 Jun 2011 11:13:40 -0000

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...