2 ms·
> <1GB, moderate read volume, super low write volume MySQL database It looks like an excellent candidate to put it entirely in RAM and trigger sync on writes o
by dvfjsdhgfv 6y ago
> <1GB, moderate read volume, super low write volume MySQL database
It looks like an excellent candidate to put it entirely in RAM and trigger sync on writes only, why on Earth would you need anything else.
- dkarl 6y agoThat's effectively what MySQL is going to do.
- dvfjsdhgfv 6y agoFor the most part, yes, but I was thinking about explicitly proloading all tables and indexes into RAM or even using the MEMORY engine, if it makes sense in that particular case.