[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