Get the creation time of a database from the snapshot


#1

How can we get the creation time of a table that we are restoring from a snapshot ?

Also will restoring change the table creation time ?


#2

There’s currently no way in MemSQL to get the original creation time for a table.

The CREATE_TIME you see in show table status / information_schema.tables is the time at which the table was loaded into memory, and is not stored in the snapshot.

Thus, restoring, replicating, restarting will all change the table create_time, and it should also be considered as local to the node you are querying.

I’d be interested in hearing about your use case that requires original table creation time, maybe we can come up with a workaround for now.