> From: Gordan Bobic via discuss <[email protected]> > > One of the best compromises is to configure InnoDB with 64KB pages, put it on > ZFS with recordsize=64K, and enable zstd compression on ZFS.
Sorry for hijacking the thread a bit. After the discontinuation of tokudb I chose the innodb+zfs route (bad previous/early experience with rocks, also million knobs to adjust for your workload etc) but at that time didn't think of increasing the Innodb page size to 64KB - do you have any (even rough) numbers of 16 vs 64KB (on zfs)? Also, what would be the benefit of zstd vs lz4? Higher compression ratio? rr _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
