4 ms·
The tuning is almost identical to what we have in production. A few comments: * I would probably go with ashift=12 to get better compression ratio, or even as
by throwdbaaway 6y ago
The tuning is almost identical to what we have in production. A few comments:
* I would probably go with ashift=12 to get better compression ratio, or even as far as ashift=9 if the disks can sustainably maintain the same performance. Benchmark first, of course.
* We came to the same conclusion regarding AIO recently, but just today I did more benchmark, and it looks like ZFS shim does perform better than InnoDB shim. So I think it's still fine to enable innodb_use_native_aio
* We use zstd compression from ZFS 2.0. It's great, and we all deserve it after suffering through the PR dramas.