What file systems commonly available on Linux systems are optimal for Berkeley DB database storage?
A common question we get is what file system to use under Linux? Currently, the best information we have is that ext2 is the best performing Linux file system for TP applications (but as it lacks ordered data mode, it’s likely not to be reliable). Second best is ext3, and ReiserFS is last. We don’t have performance measurement information for XFS, but we’ve seen failures in the field (XFS has problems with applications which repeatedly extend files, and that is a common usage pattern in Berkeley DB databases).
