mysql> show table status like 'data'; +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ | 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 | +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ | data | InnoDB | 10 | Compact | 3342355 | 829 | 2773483520 | 0 | 199147520 | 0 | NULL | 2006-08-23 18:58:34 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 9216 kB | +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ 1 row in set (0.43 sec) mysql> show table status like 'data'; +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ | 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 | +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ | data | InnoDB | 10 | Compact | 3085396 | 899 | 2774532096 | 0 | 199147520 | 0 | NULL | 2006-08-23 18:58:34 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 8192 kB | +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ 1 row in set (0.31 sec) mysql> show table status like 'data'; +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ | 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 | +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ | data | InnoDB | 10 | Compact | 2291389 | 1211 | 2775580672 | 0 | 199147520 | 0 | NULL | 2006-08-23 18:58:34 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 7168 kB | +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ 1 row in set (0.26 sec) mysql> show table status like 'data'; +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ | 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 | +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ | data | InnoDB | 10 | Compact | 3307951 | 839 | 2775580672 | 0 | 199147520 | 0 | NULL | 2006-08-23 18:58:34 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 7168 kB | +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ 1 row in set (0.50 sec) mysql> show table status like 'data'; +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ | 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 | +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ | data | InnoDB | 10 | Compact | 3363687 | 825 | 2775580672 | 0 | 199147520 | 0 | NULL | 2006-08-23 18:58:34 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 7168 kB | +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ 1 row in set (0.20 sec) mysql> show table status like 'data'; +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ | 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 | +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ | data | InnoDB | 10 | Compact | 2365849 | 1173 | 2775580672 | 0 | 199147520 | 0 | NULL | 2006-08-23 18:58:34 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 7168 kB | +------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+----------------------+ 1 row in set (0.41 sec)