News for hackers. Stuff that matters.

A comment on Rob Pike's Rules of Programming (1989). Parent comment

Re:Rob Pike's Rules of Programming (1989) by dvfjsdhgfv on Thursday August 13, 2020 @03:30AM (#24140847)
> <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.

[ Parent | on HN ]
Re:Rob Pike's Rules of Programming (1989) by dkarl on Thursday August 13, 2020 @08:35AM (#24142695)
That's effectively what MySQL is going to do.
[ Parent | on HN ]
Re:Rob Pike's Rules of Programming (1989) by dvfjsdhgfv on Friday August 14, 2020 @10:22AM (#24158303)
For 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.
[ Parent | on HN ]