MemSQL Reference Table Create Time

Help
1

After every server restart or memsql-ops restart, I see my reference tables are getting updated create time. What is the significance of this property?

2

Where exactly do you see the updated create time? I checked the TABLES table and didn’t see that in 7.1.

3

I am using Version: 6.7.5 and the create changes for the reference tables everytime, I restart the server.

4

How are you retrieving or displaying the create time, exactly?

5

select create_time, * from information_schema.tables
where table_name= ‘

’
6

Hi,

That is a bug in MemSQL 6.X. create_time only persists between restarts as of MemSQL 7.0.

-Adam

1 Like