mysqlshow --status

laoadiy

+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time | Check_time | Collation       | Checksum | Create_options | Comment |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| t    | InnoDB | 10      | Compact    | 4    | 4096           | 16384       | 0               | 0            | 514850816 |                | 2014-12-07 17:45:13 |             |            | utf8_general_ci |          |                |         |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+

今天用mysqlshow命令查看了一下表发现这个表的update_time不更新 执行了flush tables 也不管用 另外这个update_time指的是哪儿表字段更新还是结构