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

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.

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.

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).

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.

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.