It looks as though, when I go into my databases, and use the command
"SHOW TABLE STATUS", that InnoDB tables do not have some information.
I am on MySQL 4.1.0-alpha-debug. Has this been fixed in later versions?
Example:
mysql> show table status;
+------+--------+------------+---------+----------------+-------------
+-----------------+--------------+-----------+----------------
+-------------+-------------+------------+-------------------
+----------------+-------------------------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length |
Max_data_length | Index_length | Data_free | Auto_increment |
Create_time | Update_time | Check_time | Charset |
Create_options | Comment |
+------+--------+------------+---------+----------------+-------------
+-----------------+--------------+-----------+----------------
+-------------+-------------+------------+-------------------
+----------------+-------------------------+
| cur | InnoDB | Dynamic | 325214 | 2279 | 741294080 |
NULL | 114163712 | 0 | 337810 | NULL
| NULL | NULL | latin1_swedish_ci | pack_keys=1 |
InnoDB free: 6601728 kB |
| old | InnoDB | Dynamic | 1233005 | 10405 | 12830375936 |
NULL | 455147520 | 0 | 1545059 | NULL
| NULL | NULL | latin1_swedish_ci | pack_keys=1 |
InnoDB free: 6601728 kB |
+------+--------+------------+---------+----------------+-------------
+-----------------+--------------+-----------+----------------
+-------------+-------------+------------+-------------------
+----------------+-------------------------+
2 rows in set (2.78 sec)
Notice the "Create_time" and "Update_time" data is NULL.
Any reason?
thanx - ray
| Thread |
|---|
| • no create/update time for InnoDB from SHOW TABLE STATUS? | Unknown Sender | 19 Mar |