From owner-freebsd-fs@FreeBSD.ORG Mon Jun 13 09:25:05 2011 Return-Path: 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 E51DB1065672 for ; Mon, 13 Jun 2011 09:25:05 +0000 (UTC) (envelope-from prvs=1145dbc1e5=killing@multiplay.co.uk) Received: from mail1.multiplay.co.uk (mail1.multiplay.co.uk [85.236.96.23]) by mx1.freebsd.org (Postfix) with ESMTP id 709F78FC13 for ; Mon, 13 Jun 2011 09:25:05 +0000 (UTC) X-MDAV-Processed: mail1.multiplay.co.uk, Mon, 13 Jun 2011 10:13:14 +0100 X-Spam-Processed: mail1.multiplay.co.uk, Mon, 13 Jun 2011 10:13:14 +0100 X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on mail1.multiplay.co.uk X-Spam-Level: X-Spam-Status: No, score=-5.0 required=6.0 tests=USER_IN_WHITELIST shortcircuit=ham autolearn=disabled version=3.2.5 Received: from r2d2 ([188.220.16.49]) by mail1.multiplay.co.uk (mail1.multiplay.co.uk [85.236.96.23]) (MDaemon PRO v10.0.4) with ESMTP id md50013570687.msg for ; Mon, 13 Jun 2011 10:13:13 +0100 X-MDRemoteIP: 188.220.16.49 X-Return-Path: prvs=1145dbc1e5=killing@multiplay.co.uk X-Envelope-From: killing@multiplay.co.uk X-MDaemon-Deliver-To: freebsd-fs@FreeBSD.ORG Message-ID: From: "Steven Hartland" To: Date: Mon, 13 Jun 2011 10:13:33 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5931 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6090 Cc: Subject: Impossible compression ratio on ZFS X-BeenThere: freebsd-fs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Filesystems List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 13 Jun 2011 09:25:06 -0000 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? Regards Steve ================================================ This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it. In the event of misdirection, illegible or incomplete transmission please telephone +44 845 868 1337 or return the E.mail to postmaster@multiplay.co.uk.