Weewx with big databases

[teq...@gmail.com]

Hello,

does anyone using weewx with bigger (lot data) databases? I've about 9 years of weatherdata in mine and now have some memory problems.

Just curious if someone have also such amount of data and can show me their tweaks?

With the weewx-wdc skin i have a lot of oom kills.

Thanks.

[John Smith]

On Fri, 2 Jan 2026 at 19:32, teq...@gmail.com <teq...@gmail.com> wrote:

does anyone using weewx with bigger (lot data) databases? I've about 9 years of weatherdata in mine and now have some memory problems.

What database?

I recently tuned my weeWX DB in MariaDB with almost 2 decades worth of data from over 1.1GB down to about 180MB

 

Just curious if someone have also such amount of data and can show me their tweaks?

Sure, but you'll have to be more specific about your setup.

 

With the weewx-wdc skin i have a lot of oom kills.

Sounds like you haven't tuned things to stop them using up too much memory.

Also I recently noticed all my systems had now move lots of things in RAM to swap, setting vm.swappiness = 0 in a sysctl.d/*.conf file stopped that behaviour.

[Tom Keffer]

My sqlite database has just short of 2 million rows --- about 20 years of data. It is still very performant.

--
You received this message because you are subscribed to the Google Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/weewx-user/4cd5d83a-15eb-4a82-bc6e-555f05acdc09n%40googlegroups.com.

[vince]

Sqlite3 db here. I have 1.88 M records since Thanksgiving 2006.  No issues.

[teq...@gmail.com]

I'm using MariaDB with about 9 years of data. Back in the days it was more recommended than sqlite.

I dont made tweaks of the systems. It runs quite well since a couple of month ago. 

My weewx installation is on a Debian 13 VM with 2 cores and 4 gb of ram. My MariaDB vm has 2 cores and also 4 gb of ram. Usually thats enough for that "small" systems.