From: Date: October 12 2006 10:48am
Subject: Table status for innodb tables show "innodb free" 2 times
List-Archive: http://lists.mysql.com/mysql/202569
Message-Id: <452E0158.9000309@in-telegence.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

I recently deleted about 7.000.000 rows from a table, there are about 
4.000.000 left.
So I want to know how much space is free in table space now and execute:

mysql> show table status like "table"\G
*************************** 1. row ***************************
            Name: table
          Engine: InnoDB
         Version: 10
      Row_format: Compact
            Rows: 4354196
  Avg_row_length: 210
     Data_length: 917536768
Max_data_length: 0
    Index_length: 2294349824
       Data_free: 0
  Auto_increment: 35040856
     Create_time: 2006-10-12 10:29:36
     Update_time: NULL
      Check_time: NULL
       Collation: latin1_german1_ci
        Checksum: NULL
  Create_options:
         Comment: InnoDB free: 6144 kB; InnoDB free: 1762304 kB
1 row in set (0,26 sec)

Why does it show two values for InnoDB free? Which one is correct?

I use MySQL 5.0.21

Regards
Dominik