mysql> show table status like 'searchgroup' \G *************************** 1. row *************************** Name: searchgroup Engine: InnoDB Version: 10 Row_format: Compact Rows: 198722 Avg_row_length: 55 Data_length: 11026432 Max_data_length: 0 Index_length: 16269312 Data_free: 6291456 Auto_increment: 8000175 Create_time: 2010-10-09 06:09:20 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: 1 row in set (0.04 sec)