3 ms·
Why on earth would you configure swap on a system running an in-memory database? Presumably you use an in-memory database because you need extremely fast respon
by sciurus 8y ago
Why on earth would you configure swap on a system running an in-memory database? Presumably you use an in-memory database because you need extremely fast response times from it, but those are going to go through the roof when it starts swapping, potentially causing a cascading failure throughout systems that directly or indirectly rely on it.
Better to configure the databse to allocate less than the available system memory and refuse writes when it's out of free memory.
- falsedan 8y agoDon’t worry, the in-use parts of the swap file will be cached in memory
- vardump 8y agoWindows requires some swap to work correctly. Unlike Linux, it doesn't ever overcommit. IIRC, too little swap can make some parts of Windows work incorrectly.
- raptorfactor 8y agoDo you have an example of which "parts of Windows work incorrectly"? Windows runs just fine without a pagefile. Of course if you have a piece of software which then tries to use more memory than is physically available those allocations will fail, which in 99.99% of software results in termination or a crash, but the OS itself works just fine (as does all the software as long as you're not hitting your physical memory limits).
- vardump 8y agoI don't remember exactly what it was, but I do remember you needed about 200-300MB page file to avoid it. Of course, due to Windows no-overcommit policy, it's better to have a large page file almost always. That ensures your RAM is going to be used efficiently and not as a simple backing store that's never actually referenced.