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 coming from? Did you modify the Belchertown skin.conf to include plots of pm10_0? On Thu, Jan 27, 2022 at 3:14 PM carlo74 <[email protected]> wrote: > > ///////////////////////////////////// > 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 > <https://groups.google.com/d/msgid/weewx-user/3fb26266-f101-4347-93c0-fc67d1272e9bn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAPq0zEBzi6o9OHbL33WR2J%2BfwVqeP_prkjc61Cm06YgX7HSLJQ%40mail.gmail.com.
