Bug #26259 Provide generic support to save and retrieve per table create and update time
Submitted: 10 Feb 2007 18:01 Modified: 12 Feb 2007 11:41
Reporter: Mark Callaghan Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.0 OS:Linux (Linux)
Assigned to: CPU Architecture:Any
Tags: create, table, time

[10 Feb 2007 18:01] Mark Callaghan
Table handlers are expected to save and retrieve create, update and check time for each table. I prefer that this be provided by MySQL rather than reimplemented by each table handler.

With the current state, it is easy to not provide this data (InnoDB did not report create time in MySQL 4.0) or to provide it incorrectly (InnoDB reports the time of  file creation returned in the stat system call, not the time of table creation).

It would even better if this were done for update time, but the cost of updating table update time per update is too much. If something were done for this, it should be done in a lazy fashion.

How to repeat:
create table, run show table status
[10 Feb 2007 19:20] Mark Callaghan
It would also be nice to have the account that created the table listed in show table status. I can require users to create tables with a comment, but many users forget.
[12 Feb 2007 11:41] Valeriy Kravchuk
Thank you for a reasonable feature request. 

Note that if information you requested will be added, it is more likely to get in in INFORMATION_SCHEMA (http://dev.mysql.com/doc/refman/5.1/en/tables-table.html) than in SHOW TABLE STATUS.