Reliability of eMMc, SSD and commit_interval

1

Hi!
I have HA running in my rpi-4 fine with an 128gb industrial class microSD.
I already ordered an yellow board and my question is about this: which one is more reliable, eMMc of CM4 module or SSD NVME? (assuming that system is running on mysql and yellow board)

This is my current counters:

Sensors: 368
Lights: 64
Switches: 82
Binary sensors: 108
Automations: 40

Also, a question about mysql: commit_interval (in recorder configuration) is set do save data on mysql every X minutes, but this will keep the values between these seconds?
Let me explain: If i set commit_interval set to 30 seconds…but I also have a lot of sensors that send data to HA every 2 seconds…these sensors will have all the data saved to database? Or only one ‘data’ (the last one) every 30 seconds?
I’m confused about commit_interval…I’m not sure if all sensors data will be keeped in memory and flushed to database every 30 seconds…or only one sensor value will be saved in database every 30 seconds. Can anybody help me with that?

Tks!

2

I would always go for the SSD, simply because it is easier to replace if it get worn out.

Regarding your commit question, then commit is the command to write the data in the write queue to the storage.
There can be several writes to a database without a write to the storage media. Those that will be written once a commit command is issued.

3

Tks Wally, that’s what I tought about commit.