News for hackers. Stuff that matters.
Re:Are you sure you want to use MMAP in your database manage... by jnwatson on Friday January 14, 2022 @05:48PM (#29941574)
I have a great deal of experience in running very large memory-mapped databases using LMDB.

The default Linux settings dealing with memory mapped files are pretty horrible. The observed poor performance is directly related to not configuring several very important kernel parameters.

Re:Are you sure you want to use MMAP in your database manage... by jzwinck on Friday January 14, 2022 @06:13PM (#29941799)
Can you share a couple examples of those parameters?
Re:Are you sure you want to use MMAP in your database manage... by jnwatson on Saturday January 15, 2022 @05:20AM (#29945285)
This describes the relevant kernel variables:

https://synapse.docs.vertex.link/en/latest/synapse/devguides...

Re:Are you sure you want to use MMAP in your database manage... by sprachspiel on Sunday January 16, 2022 @02:34AM (#29954140)
These settings control writing back modified pages. The experiments in the paper are read-only. With writes the situation is even worse than shown in the paper (though tuning these settings may help a bit).