On 3 Aug 2018, at 8:36pm, Shevek <[email protected]> wrote: > We are running a 100Gb sqlite database, which we mmap entirely into RAM. We > are having trouble with parts of the disk file being evicted from RAM during > periods of low activity causing slow responses, particularly before 9am. Has > anybody played with mlock and/or madvise within the sqlite mmap subsystem to > improve this behaviour?
Is this a genuine Linux machine running on physical hardware, or is it a virtual machine ? Are you intentionally doing anything that would contend for this memory ? In other words, when a memory-mapped portion gets swapped out, does it make sense what replaced it, or is it pointless and weird ? Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
