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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
