Date: Mon, 13 Jun 2011 10:13:33 +0100 From: "Steven Hartland" <killing@multiplay.co.uk> To: <freebsd-fs@FreeBSD.ORG> Subject: Impossible compression ratio on ZFS Message-ID: <F21D6DCDBA494B4A9FDF20A13BC4947A@multiplay.co.uk>
next in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?F21D6DCDBA494B4A9FDF20A13BC4947A>