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/9cb195ab-c52c-4800-bcf2-472073cfd032n%40googlegroups.com.
