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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/d9bc381f-cca8-4f0d-8128-612513aa96e6n%40googlegroups.com.
