mysql> show table status like 'customers'; +-----------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+ | 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 | +-----------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+ | customers | MyISAM | 10 | Dynamic | 95132 | 112 | 10710644 | 281474976710655 | 5915648 | 420 | NULL | 2008-11-27 19:14:08 | 2008-12-09 10:07:46 | 2008-11-29 20:54:50 | latin1_swedish_ci | NULL | | | +-----------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+