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