Impossible compression ratio on ZFS
Edho P Arief
edhoprima at gmail.com
Mon Jun 13 11:13:40 UTC 2011
On Mon, Jun 13, 2011 at 4:13 PM, Steven Hartland
<killing at 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 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?
you can try gzipping the file to verify this...
More information about the freebsd-fs