3 ms·
Correctly tuned, it could be faster on some workloads and hardware (block-level compression really saves on disk I/O).
by empthought 9y ago
Correctly tuned, it could be faster on some workloads and hardware (block-level compression really saves on disk I/O).
- willvarfar 9y agoMy 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 :(
- kbenson 9y ago> not sure what they haven't done but wish they'd profile and fix it Sometimes a slowdown comes because somebody noticed a problem and fixed it, such as the default compile options including a nasty bug that makes it unsafe. I don't have any specific knowledge of this case, but it the kind of thing I've seem happen multiple times in the past, so I wouldn't be surprised.