///// Try running program “top" (install if necessary) to identify the processes consuming all that cpu (type ‘q’ to quit “top”) ///// [image: Schermata del 2022-01-26 22-28-00.png]
///// May be, it would be an idea to additionally deactivate all skins by adding enable = false for each skin and then re-activate them one by one. ///// Deactivate Belchertown an try with NONE and Seasons >>> All OK, no more High CPU usage ! Then I reactivate Belchertown and >>>> High CPU usage. This two screen of log are with Seasons and Belchertown [image: Schermata del 2022-01-26 23-00-27.png] [image: Schermata del 2022-01-26 23-01-35.png] I see only one difference with 'user.belchertown.getData' >>> and when the process arrive at this point the CPU grow up. I notice that the Cpu usage is high for 3 minutes from the start of 5 minutes (when the database is created) AND after for 2 minutes is in normal operation. i.e.: at 22:30:30 the cpu at 70% for 3 minutes and at 22:33:30 ca. the cpu is normal. At 22:35:30 again at 70%. And this for all the day. ///// might add - why are you running mysql and not sqlite3 ? ///// On this server I have another virtual host with wordpress and mysql database (very very small) ... so ... if I change to sqlite3, I lost all the archive of the past year or all the statistic remain? Thanks to everybody and sorry for my "base" english. Carlo Il giorno mercoledì 26 gennaio 2022 alle 22:59:24 UTC+1 vince ha scritto: > 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/3225a8d5-de03-43f8-bc64-9e702ec9077fn%40googlegroups.com.
