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 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? > > Your original question was 'why are you showing high cpu usage'
I would start by running a 'minimal' weewx setup temporarily: - stop weewx - disable 'all' skins other than Seasons or Standard - starting weewx back up - see if you are still experiencing the problem I might add - why are you running mysql and not sqlite3 ? -- 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/2cf42563-f854-493c-bfd0-afe9ac4bcd22n%40googlegroups.com.