weewx - mariadb high read and cpu utilization....

[Christian Peters]

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

[Christian Peters]

...ok...I tracked it down: I updated the 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

[Karen K]

Christian Peters schrieb am Samstag, 16. Dezember 2023 um 21:26:08 UTC+1:

Will ask Karen K.

I answered the issue with additional information requests.

 

[Karen K]

See Issue #25 for explanation and solution.