High load on the database

[J. H.]

Hello,

My mariadb database has approx. 1 million data records and the data goes back to 2019. This leads to a high load on the database. Are there any instructions or commands to reduce the size of the database, especially since only the year and month view can be displayed?

[Tom Keffer]

My sqlite database has about 2 million data records (dates back to 2007) with no performance issues. Your MariaDB database should be able to easily handle 1 M. 

Tags like $alltime will cause searches of the whole database, which can be slow. But, a tag for a year ($year) should not be a problem.

There must be something else going on. What are the symptoms?

On Thu, Sep 5, 2024 at 5:01 AM J. H. <lhl6...@gmail.com> wrote:

Hello,

My mariadb database has approx. 1 million data records and the data goes back to 2019. This leads to a high load on the database. Are there any instructions or commands to reduce the size of the database, especially since only the year and month view can be displayed?

--
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 on the web visit https://groups.google.com/d/msgid/weewx-user/1518783c-0032-4145-9ce1-49616450455dn%40googlegroups.com.

[J. H.]

Oh, thank you very much for the quick reply. I am still rebuilding the new server and had noticed this delay again.  Archiving sometimes took several minutes and there was also an error message: This was something like something running multiple times in parallel. I will write the exact error again after setting up.

J. H. schrieb am Donnerstag, 5. September 2024 um 14:15:18 UTC+2:

Oh, thank you very much for the quick reply. I am still rebuilding the new server and had noticed this delay again.  Archiving sometimes took several minutes and there was also an error message: This was someRe: [weewx-user] High load on the database

[J. H.]

Hello, I think the problem has been solved. An old plugin was called, which was no longer installed. I have now updated the weewx.conf. Everything works much faster. cheetah needs 1 second to calculate. The load is very low again. Thanks a lot