Turns out that today was the 9th anniversary of my weewx DB. PhpMyAdmin told me that my Db consumes 206MB in total - but it also said there were ~1.7M records. After panicing slightly, I found that a count() query said there were a more reasonable 4.7M rows and the directory with the DB is using a bit over 500MB.
There is no MQTT, but I don't understand how that could have any effect on storage. On Tuesday, 18 November 2025 at 5:53:05 pm UTC+10 John Smith wrote: > On Tue, 18 Nov 2025 at 18:21, 'Cameron D' via weewx-user < > [email protected]> wrote: > >> Yes, >> right from the start I used a custom schema, derived from wview, with >> floats rather than doubles. I figured that was more useful as I run a 1 >> minute interval. >> > > How big is your DB? MQTT sending loop packet info not an option? > > >> I also trimmed out most of the unused columns. This did cause extra >> problems when version 5 came along as the default skin started >> recalculating some of the derived quantities and chewing up lots of cpu >> cycles. >> > > I only removed columns that only had NULLs, which I figured can't have > been useful or used at all... > > >> So I am happy with the result and have to remember not to complain when I >> get to reassemble the broken bits. >> > > That's what stopped me previously, but I wanted to add forecast columns > the Vantage console already sends, but wasn't being saved, after adding > them the data just started flowing immediately... > > >> And I know nothing about hail - except that the recent storm with 5cm >> hail took chunks out of the top of my rain collector and off the bottom of >> the Stephenson box. And one cup of the anemometer is missing (but I don't >> know it that was hail or cockatoos) >> > > Sorry to hear about your loss... > > A previous station from the early 2000s lost an anemometer arm, that I can > only put down to UV, there wasn't any hail at the time.. Maybe a fat pigeon > sat on it and broke it off... I still haven't taken the broken wind sensor > down and it still has the other 2 arms almost a decade later... So who > knows what the actual cause was... > > I have since been sent a link to a listing that claims to be an all in one > sensor that can record hail, but it also says suitable for the highway what > ever that means... and +/- 10% accurate... > > > https://www.alibaba.com/product-detail/RS485-RS232-SDI12-ABS-MODBUS-RADAR_1601167771067.html > ? > -- 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/e35338f3-9892-4a0f-88b9-55d333cd7686n%40googlegroups.com.
