Bug #18229 (Documentation?) Bug - SHOW TABLE STATUS
Submitted: 14 Mar 2006 15:53 Modified: 15 Mar 2006 23:36
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:4.1.15 OS:Linux (Debian)
Assigned to: Paul DuBois CPU Architecture:Any

[14 Mar 2006 15:53] [ name withheld ]
Description:
if i follow documentation, SHOW TABLE STATUS returns update time information since MySQL 3.23.x. Thats okay for MyIsam tables. But for InnoDB it returns null always. I didn't check this out for other engines.

How to repeat:
mysql$ show table status like <innodb_table>;

http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html

Suggested fix:
complete documentation. or fix in InnoDB.
[14 Mar 2006 16:46] MySQL Verification Team
Thank you for the bug report. It is documentation issue, MyISAM tables uses
the file timestamp for, InnoDB uses a tablespace then can't get the same
information. Changing to documentation Category.
[15 Mar 2006 23:36] Paul DuBois
Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).
[11 Apr 2012 18:15] John Russell
Added some more detail to the documentation regarding Update_Time and InnoDB tables. Even with .ibd files it's not practical to derive a "last modified" time from the file timestamp, because of change buffering.