[weewx-user] Re: High CPU usage with Mysql and GW100 driver

2022-01-26 Thread 'Cameron D' via weewx-user
Is it normal in your setup to have two weewxd processes? And two mysqlds. I run MariaDB so not exactly the same, but I only have one of each. Have you checked memory usage to see you are not paging/swapping? On Tuesday, 25 January 2022 at 9:04:35 pm UTC+10 carlo74 wrote: > All server software

[weewx-user] Re: High CPU usage with Mysql and GW100 driver

2022-01-26 Thread 'Cameron D' via weewx-user
I withdraw that question - having installed htop and used tree mode I can see far more mysqld and weewx processes On Wednesday, 26 January 2022 at 6:51:45 pm UTC+10 Cameron D wrote: > Is it normal in your setup to have two weewxd processes? And two mysqlds. > I run MariaDB so not exactly the s

[weewx-user] Re: High CPU usage with Mysql and GW100 driver

2022-01-26 Thread carlo74
I activate MySql log and now I see thousand and thousand of row like this for "lightning_distance" "pm2_5" and "pm10_0" 2022-01-26T10:45:26.498249Z 20 QuerySELECT avg(lightning_distance) FROM archive WHERE dateTime > 1641246300 AND dateTime <= 1641246600 AND lightning_distance

[weewx-user] Re: High CPU usage with Mysql and GW100 driver

2022-01-26 Thread vince
On Wednesday, January 26, 2022 at 2:53:42 AM UTC-8 carlo74 wrote: > I activate MySql log and now I see thousand and thousand of row like this > for "lightning_distance" "pm2_5" and "pm10_0" > > 2022-01-26T10:45:26.498249Z 20 QuerySELECT > avg(lightning_distance) FROM archive

[weewx-user] Re: High CPU usage with Mysql and GW100 driver

2022-01-26 Thread carlo74
/ Try running program “top" (install if necessary) to identify the processes consuming all that cpu (type ‘q’ to quit “top”) / [image: Schermata del 2022-01-26 22-28-00.png] / May be, it would be an idea to additionally deactivate all skins by adding enable = false for each skin and

[weewx-user] Re: High CPU usage with Mysql and GW100 driver

2022-01-26 Thread vince
Your English is fine! Next disable Seasons and Standard and turn on 'minimal' Belchertown. Set mqtt_websockets_enabled = 0 so it only updates the data every 300 seconds. Then restart weewx and check your cpu usage. -- You received this message because you are subscribed to the Google Groups "

[weewx-user] Re: High CPU usage with Mysql and GW100 driver

2022-01-26 Thread 'Cameron D' via weewx-user
So what is unusual about lightning_distance and PM2.5? Are you asking it to plot them, but have no data? It is quite possible to migrate your data between mysql and sqlite3, but that will not make much difference to your problem - your weewx system seems to be stuck in a loop trying to get that

[weewx-user] Re: High CPU usage with Mysql and GW100 driver

2022-01-27 Thread Karen K
What about # Air Quality Index (AQI) defaults aqi_enabled = 0 aqi_location_enabled = 0 # Earthquake defaults earthquake_enabled = 0 either in skin.conf or weewx.conf for Belchertown skin? Note: weewx.conf takes precedence over skin.conf. Cameron D schrieb am Donnerstag, 27. Januar 2022 um

[weewx-user] Re: High CPU usage with Mysql and GW100 driver

2022-01-27 Thread carlo74
/ Next disable Seasons and Standard and turn on 'minimal' Belchertown. Set mqtt_websockets_enabled = 0 so it only updates the data every 300 seconds. Then restart weewx and check your cpu usage. /// *Nothing, I try and always Hi

Re: [weewx-user] Re: High CPU usage with Mysql and GW100 driver

2022-01-27 Thread Tom Keffer
It looks like something is requesting the average value for "pm10_0" over 5 minute intervals, which is pretty silly because your archive interval is 5 minutes. If you search the source code for the Belchertown skin, you do not find the string "pm10_0" anywhere, so I wonder where this request is co

Re: [weewx-user] Re: High CPU usage with Mysql and GW100 driver

2022-01-27 Thread vince
I did notice you have at least some errors in your weewx.conf You are trying to MQTT subscribe to nonexistent topics [[[first/topic]]] [[[FIRST/REPLACE_ME]]] [[[SECOND/REPLACE_ME]]] Also - did you add a custom graphs.conf file to your Belchertown installation to define pm10_0 perhaps ? If so,