Unwrap text
Report abuse
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 |
+--------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+------------------------+