Impossible compression ratio on ZFS
killing at multiplay.co.uk
Mon Jun 13 09:25:06 UTC 2011
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*
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
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 at multiplay.co.uk.
More information about the freebsd-fs