[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Database back up again
The database is back up and running. It looks like the table that holds
the observations got corrupted, but I was able to repair it.
TR20 is loaded into the database, and I'll be working on TR21 and TR22
soon. And the database has just passed 100 million V/I pairs of
measurements!
On the database problem, does anyone know if MySQL has a size limit on
index files? I know there are size limits/defaults on the tables
themselves (which I ran into a while back with the observations table)
that can be tweaked, but I haven't found anything on the index files.
It would probably make sense to break up my observations table (which is
now 8.9 gigs in size) into several smaller tables. But then I'd have to
re-code all the database queries. :-(
Mike