Recommended DB Buffers and Unicorn Workers

Installation
1

Hi,
I would like to know if what I got for db buffers and unicorn worker is good for my machine.

So, I have a VM with 4vCPU and 32 RAM. I set db buffers to 8000MB and 10 unicorn workers. Does this setting is good for my VM?

Johnny

2

Depends on how big your database is. If you have 500meg database, giving it 8gb of shared buffers is pointless.

3

I have a 140GB NVMe disk space.

4

I don’t mean to be rude here but

Sam: What is your petrol gauge at?
Johnny: I own a petrol station

2 Likes
5

Lol! All good Sam. So having a 140GB NVMe with 4 CPUs and 32GB or RAM is safe to say that 8GB of shared buffers and 10 unicorn workers is healthy?

6

Impossible to say anything without knowing real world load you have, where the bottlenecks are, how big your database is and so on.

Go with what the discourse setup script recommends, and if you have performance issues you can report back here with more specifics about your load, database size and so on.

If your forum is just starting out then your database is tiny. Giving it 8 gigs or RAM to keep the DB in memory is not going to make any diff.

1 Like
7

Got it… Thanks for your insight.