Perhaps a bit of background, I started coding Fortran on state of the art IBM1620, I whole total 16k of memory. It filled a large room. That teaches you to conserve assets. I am retired so time is not something I worry about. I wrote my first shopping cart in mid-90's and had a bunch of emails from Widenius and Lerdorf about mysql and php,I was able break them pretty regularly for couple of years.
When I looked at archive table in phpmyadmin it shows index is small. When I look at the actually db files on server --right now each day archive used almost 100k, so removing say 25 columns is a bunch and also makes everything run faster. Anyway still don't understand why I would get errors if weewx truely just looks at the column list. This is a lot better than sitting in front of a tv eating chips. On Thursday, February 13, 2020 at 4:54:46 PM UTC-6, ed100 wrote: > > I have the Belchertown skin with MQTT running nicely after some serious > help from folks here. > There are a bunch of fields in the weewx mariadb database that I will > never use. I did some searching to how to do this but didn't find out how. > I don't want to damage things, just clean up unnecessary fields. (old > habits...) > I did grab the extraTemp1 and use it to show the cpu temp on the weewx > raspberry. > > Thanks > -- 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/d054fa06-772f-4a24-ac60-1d8dc16309e2%40googlegroups.com.
