Impossible compression ratio on ZFS

[Edho P Arief]

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