Innodb表的创建时间

Innodb表的创建时间

本文介绍了Innodb表的创建时间的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

CREATE_TIME列显示了我所有InnoDB表的相同CREATE_TIME.这意味着所有这些表都是在2010-03-26 06:52:00到2010-03-26 06:53:00之间创建的,而实际上它们是在几个月前创建的.

CREATE_TIME column of "TABLES" table from INFORMATION_SCHEMA shows the same CREATE_TIME for all my InnoDB tables. It means all these tables were created between 2010-03-26 06:52:00 and 2010-03-26 06:53:00 while actually they were created a few months ago.

InnoDB表的CREATE_TABLE字段是否会自动更改?

Does the CREATE_TABLE field change automatically for InnoDB tables?

推荐答案

对于InnoDB,INFORMATION_SCHEMA.TABLES中的CREATE_TIME值基于表的FRM文件的修改时间.因此,这很可能代表您上次运行ALTER TABLEOPTIMIZE TABLE的时间.

For InnoDB, the CREATE_TIME value in INFORMATION_SCHEMA.TABLES is based on the modified time of the table's FRM file. So this will most likely represent the last time you ran ALTER TABLE or OPTIMIZE TABLE.

这篇关于Innodb表的创建时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-05 03:15