Post #3162097
2022-11-02 20:50 UTC
@Gargron@mastodon.social Also most DB engines really need a sh*t-ton of RAM. If the DB has to go to disk - even SSD - you’re in a world of pain. Biggest challenge is to balance RAM / CPU. Sometimes need to tweak OS VM paging parms as well. A good DB does its own paging, as these workloads differ greatly from regular processes.
Replies (1)
-
@ghard@mastodon.social 2022-11-02 20:54
@Gargron@mastodon.social Most DB setups using shared-nothing clustering/sharding aren’t to increase CPU counts, but rather to increase available RAM.