I “upgraded” to MariaDB awhile back and is it just my imagination or is my database growing faster than it did with SQLite? I upgraded with the expectation that I would be able to keep more days of history but it seems I can actually keep LESS than before. My database is growing by nearly 2 million …

Yeah, since major things were done improving built-in db using mariadb is lately considered more as downgrade than upgrade. A year or more ago it was a good choice, but not anymore, i guess. There’s a guide somewhere in this forum how to revert back to built-in db.

Reverting to SQLite seems like just a matter of removing the line from the configuration.yaml file. The old database is still there. I assume the old data would get purged. I’d like to understand better WHY MariaDB is no longer an upgrade. What happened?

MariaDB is better with a large DB, because it can be accessed at multiple points. SQLlite is just a file with its limitations. Whatever you DB is you should make sure it is configured to store the correct data Some sensors produce data that can make the database grow fast. I had made a Node Red …

How do I configure it to store some data and not other data? My database definitely qualifies as large. Around 2 million records a day. Things like grid voltage and battery power change every 5 seconds.

The official documentation. [image] Recorder Instructions on how to configure the data recorder for Home Assistant. And a guide that should still be usable. [image] How to keep your recorder database size under control Community Guides …

[image] haysdb: Reverting to SQLite seems like just a matter of removing the line from the configuration.yaml file. The old database is still there. No, it’s not that simple. Ok, old (mariadb) database indeed remains, but HA starts new blank db and all history is lost. If you want to keep it …

[image] haysdb: I “upgraded” to MariaDB awhile back and is it just my imagination or is my database growing faster than it did with SQLite? How far back in time you moved to MariaDB? If it is just recent move, than this is normal, as in old database you have already stable situation with new …

[image] Protoncek: If you manage connect to sqlite (between two Ha writes i guess) then ha immediately starts a new, blank db, as current one is not accesible to HA anymore (been there, done that). I had this happen in the past a couple of times without me trying to access it another way, pro…

Exactly the reason i went to MariaDB back then - sqlite tends to crash out of the sudden. Then i’ve read that a couple of times HA made some big improvements in sqlite sb, so i took the bite and went back. All is ok so far for quite some months now (i’d say near one year or so). As a backup i instal…

I’m going to stay with MariaDB until something forces me to abandon it. My system adds 2 million records a day and that will grow by quite a bit if I replace the bluetooth BMS integration which updates only every 30 seconds to Modbus with updates every 5 seconds.

MariaDB database growth is > than SQLite

Installation

WallyR (Wally) May 16, 2025, 3:38pm 6

The official documentation.

And a guide that should still be usable.