3 ms·
Yes. Most RDBMS are memory-bound (indexes, connection overhead, buffer pool…), so the more, the better. At my last job, I switched a large-ish (100K QPS at pea
by sgarland 3y ago
Yes. Most RDBMS are memory-bound (indexes, connection overhead, buffer pool…), so the more, the better.
At my last job, I switched a large-ish (100K QPS at peak) m5 MySQL instance to a smaller (in AWS numbering) r6i that was cheaper, despite having the same amount of RAM and being generation newer. That, combined with careful tuning and testing, resulted in queries speeding up 20-40%, AND we then had plenty of room for vertical scaling again if necessary.