Innodb表的创建时间 [英] Creation time of Innodb tables

问题描述

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 TABLE或OPTIMIZE 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表的创建时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！