Databases and ZFS
ZFS 尽管有上佳的表现,但是在数据库应用上还是必须“应库而异”。
这篇文章介绍的5个要点可以说是每个 SA 必须了解的。
- Match the database block size with ZFS record size.
- If you have a write heavy workload, you are better off by separating the log files on a separate pool
- Tune down the vdev_cache using ztune.sh until 6437054 is fixed
- Tune vq_max_pending using ztune.sh until 6457709 is fixed
- Let ZFS auto-tune. It knows best. In cases were tuning helps, expect ZFS to incorporate that fix in future releases of ZFS