My understanding is that ZFS compresses to multiples of the sector size, so it's the same ratio as innodb page compression gives but ought be much faster and tr

My understanding is that ZFS compresses to multiples of the sector size, so it's the same ratio as innodb page compression gives but ought be much faster and transparent. My own experiments put tokudb far far ahead: https://williamedwardscoder.tumblr.com/post/160628887798/compressing-mysql-databases https://williamedwardscoder.tumblr.com/post/160628887798/com... Unfortunately tokudb has taken a massive performance hit recently - it was so fast when tokutek integrated it into 5.6 but the percona and Mariadb packaging in 5.7 is much slower than innodb - not sure what they haven't done but wish they'd profile and fix it - you'd think that percona, having brought tokutek - would have noticed and benchmarked and care :(