Hi,

I've just converted my databases so they are using per_table tablespaces.
When I do a show table status in that database the Comment line still shows
the amount free, but I assume this doesn't mean anything now ??  It doesn't
make sense ?

*************************** 1. row ***************************
           Name: FromTo
         Engine: InnoDB
        Version: 9
     Row_format: Dynamic
           Rows: 54947
 Avg_row_length: 86
    Data_length: 4734976
Max_data_length: NULL
   Index_length: 21610496
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2005-07-21 11:00:11
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options: 
        Comment: InnoDB free: 7168 kB
*************************** 2. row ***************************
           Name: Routing
         Engine: InnoDB
        Version: 9
     Row_format: Dynamic
           Rows: 425
 Avg_row_length: 21010
    Data_length: 8929280
Max_data_length: NULL
   Index_length: 0
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2005-07-21 11:00:12
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options: 
        Comment: InnoDB free: 4096 kB

Regards,

Marvin.


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to