MySQL show Table Status field

Show table status returns the following fields:

• Name

Table name.

• Engine

Table storage engine. Before MySQL 4.1.2, this value is marked as type.

• Version

The version number of the. frm file of the table.

• Row_format

Row Storage Format (fixed, dynamic, compressed, redundant, compact ). The InnoDB table format is reported as redundant or compact.

• Rows

The number of rows. Some storage engines, such as MyISAM, store precise numbers.

For other storage engines, such as InnoDB, the current value is an approximate number, which is 40 to 50% different from the actual value. In these cases, select count (*) is used to obtain the exact number.

For tables in the information_schema database, the rows value is null.

• Avg_row_length

The average length of a row.

• Data_length

The length of the data file.

• Max_data_length

Quantity
The maximum length of the data file. Given the Data Pointer size, this is the total number of bytes of data that can be stored in the table. The maximum storage capacity supported by MySQL versions later than MySQL 5 is very large.
The column is 256 TB. The maximum storage capacity of a table is limited by OS. But now, Linux ext3
FS supports a single maximum file size of 2 TB, so you don't have to worry too much about this problem. If the storage engine is InnoDB, the value is
The value displayed in status is always 0. I don't know why.

• Index_length

The length of the index file.

• Data_free

Number of unused bytes in the ascending order.

• Auto_increment

The next auto_increment value.

• Create_time

When is the table created.

• Update_time

When is the data file last updated.

• Check_time

When is the table last checked. Not all storage engines are updated at this time. In this case, the value is null.

• Collation

The character set and collation of the table.

• Checksum

Activity verification value.

• Create_options

And create table.

• Comment

Comments used when creating a table (or descriptions about why MySQL can access table information ).