[weewx-user] Re: weewx - mariadb high read and cpu utilization....

[Karen K]

See Issue #25  for 
explanation and solution.

-- 
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/ecb9bb66-5ab2-4c95-9eac-a10e9922f94an%40googlegroups.com.

[weewx-user] Re: weewx - mariadb high read and cpu utilization....

[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.
 

-- 
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/3c9ccd9f-9f2f-4acc-814c-963ffe1d6aean%40googlegroups.com.

[weewx-user] Re: weewx - mariadb high read and cpu utilization....

['Christian Peters' via weewx-user]

...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 


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/s0.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(  CASEWHEN `outTemp`>1000.0 THEN 0.0WHEN `outTemp`>86.0 
> THEN 36.0WHEN `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.