Ah! I see. That does not strike me as a particularly large MariaDB database, but I can't claim to be an expert.
On Fri, Aug 14, 2026 at 2:01 PM Bob Atchley <[email protected]> wrote: > Thanks > I should have said i'm using mariadb ... I think that has an OPTIMISE > TABLE equivalent to VACUUM, but no I have not used it (I'll experiment on > an off line database). > It wasn't clear to me what extra derived types I needed, and the extended > schema should give me future compatibility ... so no regrets other working > out how I will back it up. > > On Friday, 14 August 2026 at 21:14:04 UTC+1 Tom Keffer wrote: > >> Have you tried the VACUUM <https://sqlite.org/lang_vacuum.html> command? >> >> Also, you did not need to switch to the wview-extended schema, just add >> columns for any derived types. See *Troubleshooting V5 performance >> issues <https://github.com/weewx/weewx/wiki/v5-performance-troubleshooting>* >> . >> >> On Fri, Aug 14, 2026 at 1:04 PM Bob Atchley <[email protected]> wrote: >> >>> Raspbian BullsEye is end of life at the end of August 2026 (2 weeks >>> time as I write this). >>> With the number of security issues being dug up by AI, doing nothing is >>> a high risk strategy. >>> >>> I decided to make the move to Ubuntu 26.04 on my RPi4 (giving a upgrade >>> path going forward) and of course the latest weewx version (5.5.0). >>> >>> The biggest hurdle is that weewx doesn't break, so not touched it for >>> years and I have forgotten everything. >>> Great documentation and the Wiki are the saving graces. >>> >>> On BullsEye I was running a very early (beta) release of weewx 5.0 using >>> the old database schema and just using the standard Seasons Skin, >>> I realised I had a serious performance issue after the upgrade: >>> >>> Before: >>> user.log.1:Aug 8 23:25:21 rpi4 weewx[965] INFO weewx.imagegenerator: >>> Generated 10 images for report SeasonsReport in 0.74 seconds >>> user.log.1:Aug 8 23:30:21 rpi4 weewx[965] INFO weewx.cheetahgenerator: >>> Generated 8 files for report SeasonsReport in 2.28 seconds >>> >>> After: >>> 026-08-14T14:37:47.234310+00:00 rpi4 weewxd[5648]: INFO >>> weewx.cheetahgenerator: Generated 8 files for report SeasonsReport in >>> 144.66 seconds >>> 2026-08-14T14:43:52.117916+00:00 rpi4 weewxd[5648]: INFO >>> weewx.imagegenerator: Generated 10 images for report SeasonsReport in >>> 364.88 seconds >>> >>> so 4 seconds to write the reports before, 500 seconds after, with 100% >>> CPU usage. Disappointing. >>> >>> Reading between the lines more use is being made of the extended >>> database schema, causing a large overhead if still using the old schema. >>> So I followed the Wiki: >>> >>> https://github.com/weewx/weewx/wiki/Switching-to-the-new-wview_extended-schema >>> >>> This solved the performance issues: >>> 2026-08-14T18:40:28.340408+00:00 rpi4 weewxd[7306]: INFO >>> weewx.cheetahgenerator: Generated 8 files for report SeasonsReport in 5.37 >>> seconds >>> 2026-08-14T18:40:29.342990+00:00 rpi4 weewxd[7306]: INFO >>> weewx.imagegenerator: Generated 10 images for report SeasonsReport in 1.00 >>> seconds >>> >>> This is perfectly acceptable performance. >>> >>> The downside is my database when backed up is now 1.4GB (95MB gzipped) - >>> basically double the size from before. >>> >>> My backup strategy has been to use google cloud (via rclone) but I was >>> getting bandwidth limit errors before this increase of size. >>> Still need to work out how to fix this. >>> >>> Hope this helps anyone else doing something similar >>> >>> Cheers >>> >>> Bob >>> >>> -- >>> 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 visit >>> https://groups.google.com/d/msgid/weewx-user/430e8248-f7a5-401d-8fb1-d3807c2baed5n%40googlegroups.com >>> <https://groups.google.com/d/msgid/weewx-user/430e8248-f7a5-401d-8fb1-d3807c2baed5n%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 visit > https://groups.google.com/d/msgid/weewx-user/392bae75-b470-4027-b088-0064ec27bc4an%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/392bae75-b470-4027-b088-0064ec27bc4an%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 visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEDsFAjq5giVJoLU-82w-ySvxOJdG_%2B%2BTFzCk-Oz8CmuNw%40mail.gmail.com.
