Re: New HDB backend MDB

Nico Williams <[email protected]>
Newsgroups gmane.comp.encryption.kerberos.heimdal.general
Message-ID <CAK3OfOhZ4sYDgK9Bz-W=7wcqOcfRRkX4B=9QzNfdEiZrkezSZA@mail.gmail.com>
Hi,

You say on one slide that

"
 o Surveying the landscape revealed no other database libraries with
the desired characteristic
"

But SQLite3 with WAL (write-ahead logging) has very similar
characteristics to your MDB: MVCC, serialized writing, support for
in-memory and on-disk databases (MDB doesn't do on-disk).

Did you consider SQLite3 w/ WAL?

My suspicion is that if you don't need (or want) the full overhead of
SQL then MDB can probably perform much better than SQLite3 w/ WAL.
Have you benchmarked the two?

What makes your write throughput so slow relative to BDB?  Do you
fsync() more often than you have to?  When do you fsync()?  Your write
transaction rate does seem high for, say, a single traditional disk...
 What is the on-disk file format like?  I gather the file format is
the same as memory + whatever appends are needed as pages are
allocated.  The DB format reminds me a lot of ZFS, with just two
ubberblocks (pages #0 and #1) and with btrees (well, one b-tree,
right?) instead of directories and files.

This looks very interesting.  Thanks,

Nico
--
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.