That query is asking for every single record over 4 years of data --- about 400,000+ records with a 5 minute archive interval. That's not the use pattern when an xtype is causing the problem <https://github.com/weewx/weewx/wiki/XTypes-performance>.
It's hard to imagine why the Belchertown skin would need data at that density. Try isolating the problem by shutting off the imagegenerator, then the cheetahgenerator (you can do that by modifying generator_list in skin.conf). Then once you know which one is the culprit, then start trimming their respective sections in skin.conf until you isolate the plot or tag that is causing the problem. On Mon, May 27, 2024 at 4:47 PM Mark Jenks <mjenks1...@gmail.com> wrote: > Just built a new weewx on my Fedora 38 this morning, and attached it to my > mariadb. It has 13 years worth of data in it. > > I am running Belchertown and mqtt, and installed Windy. But I just > removed Windy to see if that was it, but still does it. Python and/or > moriadb goes to 100% CPU. > Mariadb says the high query during that time is: SELECT * FROM archive > WHERE dateTime > 1320346500 AND dateTime <= 1716824400 ORDER BY dateTime ASC > But that makes no sense, since I can query my entire archive table (select > *) in about 3 seconds. > > Any thoughts on how to catch what is going on? I could enable debug, but > hoping for a better way other that looking at a ton of logs. > > Thanks! > > > > -- > 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+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/a882fb44-d36b-4bf4-8588-41199524b5f7n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/a882fb44-d36b-4bf4-8588-41199524b5f7n%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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEDNeJx-PbWid15WJMtAdv5-0rVLwjGw%2BZDwkbBrw5pGOw%40mail.gmail.com.
