filesystem semantics for data bases

Does anyone know which file system semantics current database systems (e.g. mysql) need. I searched throughout the net and found th开发者_开发技巧at the BerkleyDB you can read, that every file system with POSIX semantics can be used. But I wonder if true POSIX semantics are really needed or if a subset is sufficient.

Any hint will be appreciated.

One way to look for your answer is to search for answers to questions such as "running BerkeleyDB out of NFS". Since NFS is very common, but has relaxed semantics, these answers have surely been asked.

It might not be a complete answer, but the section 2.0 of the article "Atomic Commit In SQLite" discusses the assumptions on the underlying storage.