Bug #11826 | SHOW TABLE STATUS: CHECK TIME not updated for InnoDB tables | ||
---|---|---|---|
Submitted: | 8 Jul 2005 23:06 | Modified: | 19 Aug 2005 1:06 |
Reporter: | Roland Bouman | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
Version: | 5.0.7 | OS: | Windows (Win XP Professional SP2) |
Assigned to: | Paul DuBois | CPU Architecture: | Any |
[8 Jul 2005 23:06]
Roland Bouman
[8 Jul 2005 23:44]
MySQL Verification Team
In my opinion here is a documentation issue clarifying the reason why these variables can't be updated for InnoDB storage engine: mysql> show table status like 't_%'\G *************************** 1. row *************************** Name: t_innodb Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2005-07-08 20:27:36 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: InnoDB free: 4096 kB *************************** 2. row *************************** Name: t_myisam Engine: MyISAM Version: 10 Row_format: Fixed Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 1970324836974591 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2005-07-08 20:27:27 Update_time: 2005-07-08 20:27:27 Check_time: 2005-07-08 20:29:02 Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 2 rows in set (0.03 sec)
[9 Jul 2005 0:34]
Roland Bouman
Oh, I can't believe I typed CREATE TIME in the synopsis field instead of CHECK TIME, stupid me. Anyway, will this documentation include info include info on how to find out what the last check time actually was for InnoDB tables?
[11 Jul 2005 11:23]
Heikki Tuuri
Modifying the synopsis, as the bug is about CHECK TABLE time. This is a documentation issue. Or in 5.1, we could put the time to the InnoDB system tables or the .frm file, or in the information schema. Regards, Heikki
[19 Aug 2005 1:06]
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). Additional info: I'll update the manual to indicate that this field is NULL for engines that don't update it.