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/a6578dc6-80f7-4958-8501-a0d1483f69fen%40googlegroups.com.
