...ok...I tracked it down: I updated the * weewx-GTS <https://github.com/roe-dl/weewx-GTS> * xtype extension in October. I disabled the xtype_service *user.GTS.GTSService * and the querys and high load and I/O is gone. Will ask Karen K.
Regards, Christian Christian Peters schrieb am Samstag, 16. Dezember 2023 um 20:42:30 UTC+1: > Hi all, > > i just updated my weewx vm and noticed high cpu load since end of October > (average was 20% cpu load, now 80%cpu load). > Maybe this is my fault as I added some features but I can't remember what > could cause this? Maybe a typo in weewx.conf. > I did an iotop -o and get this, even if weewx is idle and did all things > in the 1min interval. : > > 694 be/4 mysql 25.99 M/s 0.00 B/s mariadbd > > So there is a constant sending of the database I think? > I'm not very experienced but I google a littel bit and did this: > login into mysql and did a > > SHOW PROCESSLIST; > > I do this many times and I see if weewx runs at 15sec after full minute to > 45sec it query the data and send it into the database. > But I see all the time this one line sending data...: > > | 121 | weewx | localhost | weewx_new | Query | 1 | Sending data | > SELECT sum( CASE WHEN `outTemp`>1000.0 THEN 0.0 WHEN `outTemp`>86.0 > THEN 36.0 WHEN `outTem | 0.000 | > > What could be the reason for this!? This line never dropped, seems to > cause the high read and cpu!? > > Any idea howto debug this...? > > Thanks in advance... > > Regards, > > Christian > > -- 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/c5707797-67e1-4774-b913-b9c1c44cc039n%40googlegroups.com.
