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/c4580b80-deb1-4e77-ae0e-5cfc7306750fn%40googlegroups.com.
