> Try using sqlite and see if that's faster. It is, very much so--but it also doesn't have a 5M-row archive to deal with. But at least as a test, it's quite snappy, and it generates the Seasons report in a matter of seconds. I'll try enabling other uploaders/reports and see if it continues to run fine.
Is it possible to import the MySQL data into this database? On Saturday, June 27, 2026 at 3:42:32 PM UTC-4 Tom Keffer wrote: > On Sat, Jun 27, 2026 at 12:03 PM [email protected] <[email protected]> > wrote: > >> > MySQL server. You had a "Cannot connect" error on startup, so there is >> something flaky about the connection. >> >> It seems weewx starts up earlier than mysql, and thus fails to connect. >> It also seems to shut down earlier (on system shutdown or reboot) than >> mysql, leading to errors then. >> >> Enabling the general query log and following it doesn't show anything >> obvious. Nothing gets logged to the slow query log. >> > > It should show the types of queries running and how long they take. Are > you saying they were all quick? The time *must* be going somewhere! > > Trying to rule out sources of a slowdown, I moved the VM storage to a >> local disk (it had been over the network), and again rebooted. And it now >> quickly generates the index.html page for the Seasons report, but it still >> seems to be struggling to create the -- >> > > Good idea. Try using sqlite and see if that's faster. > > -tk > -- 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/9b599429-84bb-4389-81f3-5434a8d9b938n%40googlegroups.com.
