///////////////////////////////////// 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 High CPU usage* ///////////////////////////////// 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. ///////////////////////////////// *I use another method to insert data of PM2_5, PM10_0 and lightning >>* https://github.com/tkeffer/filepile I re-controlled the Mysql log file and i suppose that the problem is at the moment of "query" the database of 3 values: pm2_5 pm10_0 and lightning. Here an excerpt of log file and only for pm10_0 it was thousand and thousand of row 2022-01-26T10:37:36.960712Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645402800 AND dateTime <= 1645403100 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.961776Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645403100 AND dateTime <= 1645403400 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.962752Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645403400 AND dateTime <= 1645403700 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.963524Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645403700 AND dateTime <= 1645404000 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.964263Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645404000 AND dateTime <= 1645404300 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.964989Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645404300 AND dateTime <= 1645404600 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.966022Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645404600 AND dateTime <= 1645404900 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.966960Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645404900 AND dateTime <= 1645405200 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.967965Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645405200 AND dateTime <= 1645405500 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.969014Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645405500 AND dateTime <= 1645405800 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.969930Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645405800 AND dateTime <= 1645406100 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.970924Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645406100 AND dateTime <= 1645406400 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.972136Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645406400 AND dateTime <= 1645406700 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.973038Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645406700 AND dateTime <= 1645407000 AND pm10_0 IS NOT NULL 2022-01-26T10:37:36.973989Z 16 Query SELECT avg(pm10_0) FROM archive WHERE dateTime > 1645407000 AND dateTime <= 1645407300 AND pm10_0 IS NOT NULL Tanks to everyone Carlo Il giorno giovedì 27 gennaio 2022 alle 10:48:23 UTC+1 [email protected] ha scritto: > 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 01:25:04 UTC+1: > >> 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 lightning and PM2.5 data. >> >> On Wednesday, 26 January 2022 at 8:53:42 pm UTC+10 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 Query SELECT >>> avg(lightning_distance) FROM archive WHERE dateTime > 1641246300 AND >>> dateTime <= 1641246600 AND lightning_distance IS NOT NULL >>> 2022-01-26T10:37:18.348249Z 16 Query SELECT avg(pm2_5) >>> FROM archive WHERE dateTime > 1671106500 AND dateTime <= 1671106800 AND >>> pm2_5 IS NOT NULL >>> >>> Now I stop log file because in half an hour the file is 150MB >> HUGE !!! >>> >>> What can I do? >>> Thanks >>> Carlo >>> Il giorno mercoledì 26 gennaio 2022 alle 10:12:01 UTC+1 Cameron D ha >>> scritto: >>> >>>> 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 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 update to the last version: >>>>>> mysqld 8.0.27 >>>>>> weewx 4.5.1 >>>>>> GW1000 0.4.1 >>>>>> >>>>>> I have a high CPU usage all the day at 50/60/70% of CPU. Why? >>>>>> >>>>>> [image: htop.jpg] >>>>>> >>>>>> [image: cockpit.jpg] >>>>>> >>>>>> and on syslog, sometimes: >>>>>> >>>>>> pcp-pmie[1855]: High aggregate context switch rate 10453ctxsw/s@server >>>>>> >>>>>> Today, after this message on syslog, my server crash and stop working: >>>>>> >>>>>> pcp-pmie[1749]: High aggregate context switch rate 9416ctxsw/s@server >>>>>> pcp-pmie[1749]: High average processor utilization 97%util@server >>>>>> pcp-pmie[1749]: High per CPU processor utilization >>>>>> 97%util[cpu0]@server 97%util[cpu1]@server >>>>>> >>>>>> Can you help me? >>>>>> Thanks >>>>>> Carlo >>>>>> >>>>> -- 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/3fb26266-f101-4347-93c0-fc67d1272e9bn%40googlegroups.com.
