mysql> SHOW TABLE STATUS LIKE 'worldcities';
+-------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+
| 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                |
+-------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+
| worldcities | InnoDB |      10 | Compact    | 2731385 |             63 |   174800896 |               0 |            0 |         0 |           NULL | 2007-06-12 18:28:04 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 120832 kB | 
+-------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+

mysql> SHOW TABLE STATUS LIKE 'regions_fips';
+--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+
| 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                |
+--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+
| regions_fips | InnoDB |      10 | Compact    | 4417 |             48 |      212992 |               0 |            0 |         0 |           NULL | 2007-06-12 18:28:04 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 120832 kB | 
+--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+

mysql> SHOW TABLE STATUS LIKE 'places';
+--------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+
| 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                |
+--------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+
| places | InnoDB |      10 | Compact    | 238174 |             59 |    14172160 |               0 |            0 |         0 |         252808 | 2007-05-10 22:03:25 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 120832 kB | 
+--------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+