• Deleted data • Datafile parts • Deleted blocks • Data records • Auto increment key ,  Last value • Status • Recover time • Creation time • File-version • Chararacter set • Record format • MyISAM file myisamchk — MyISAM Table-Maintenance Utility Explanations for the types of information  myisamchk  produces are given here. “Keyfile”  refers to the index file. “Record”  and “row”  are synonymous, as are “field”  and “column.” The initial part of the table description contains these values: Name of the  MyISAM  (index) file. The format used to store table rows. The preceding examples use  Fixed length . Other possible values are  Compressed  and  Packed . ( Packed  corresponds to what  SHOW TABLE STATUS  reports as Dynamic .) The table default character set. Version of  MyISAM  format. Always 1. When the data file was created. When the index/data file was last reconstructed. Table status flags. Possible values are  crashed ,  open ,  changed ,  analyzed ,  optimized keys , and sorted index pages . The key number associated the table’s  AUTO_INCREMENT  column, and the most recently generated value for this column. These fields do not appear if there is no such column. How many bytes of unreclaimed deleted data there are. You can optimize your table to minimize this space. See Section 7.6.4, “MyISAM Table Optimization” . For dynamic-row format, this indicates how many data blocks there are. For an optimized table without fragmented rows, this is the same as  Data records . How many deleted blocks still have reserved space. You can optimize your table to minimize this space. See Section 7.6.4, “MyISAM Table Optimization” . The number of rows in the table. 573