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: 

• MyISAM file 

Name of the MyISAM  (index) file. 

• Record format 

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 .) 

• Chararacter set 

The table default character set. 

• File-version 

Version of MyISAM  format. Always 1. 

• Creation time 

When the data file was created. 

• Recover time 

When the index/data file was last reconstructed. 

• Status 

Table status flags. Possible values are crashed , open , changed , analyzed , optimized keys , and sorted index pages . 

• Auto increment key , Last value 

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. 

• Data records 

The number of rows in the table. 

• Deleted blocks 

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” . 

• Datafile parts 

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 . 

• Deleted data 

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” . 

