What Linux filesystem is best for Berkeley DB database storage?
We believe that ext2 is the best performing Linux file system for TP applications, but using it may lead to data corruption because ext2 lacks ordered data mode. For that reason we recommend using ext3, as it both performs well and supports ordered data mode. 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). Back to top I’m using integers as keys for a Btree database, and even though the key/data pairs are entered in sorted order, the page-fill factor is low. This is usually the result of using integer keys on little-endian architectures such as the x86. Berkeley DB sorts keys as byte strings, and little-endian integers don’t sort well when viewed as byte strings. For example, take the numbers 254 through 257.
