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
J. H. schrieb am Donnerstag, 5. September 2024 um 14:16:07 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 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 > > >> >> Tom Keffer schrieb am Donnerstag, 5. September 2024 um 14:11:05 UTC+2: >> >>> 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. <[email protected]> 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 [email protected]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/weewx-user/1518783c-0032-4145-9ce1-49616450455dn%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/1518783c-0032-4145-9ce1-49616450455dn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/d81b7b20-b6e9-4441-9e9c-d2025e9c363cn%40googlegroups.com.
