Mysql-show TABLE Status Command

Show Table status Gets the information for the table

Show table status like ' TableName ' \g

1.Name

Table name

2.Engine:

Table's Storage Engine

3.Version:

Version

4.row_format

The row format. For the MyISAM engine, this could be dynamic,fixed or compressed. Dynamic lines have variable line lengths, such as varchar or BLOB type fields. A fixed row is a constant line length, such as a char and an integer type field.

5. Rows

The number of rows in the table. For non-transactional tables, this value is accurate and, for transactional engines, this value is usually estimated.

6.avg_row_length

Average number of bytes per row included

7.data_length

The amount of data (in bytes) of the entire table

8.max_data_length

The maximum amount of data the table can hold

9.index_length

The amount of space the index occupies on the disk

10.data_free

For the MyISAM engine, identifies the space that has been allocated, but is not used now, and contains the space for the row that has been deleted.

11.auto_increment

The value of the next auto_increment

12.create_time

When the table was created

13.update_time

Last Update time of table

14.check_time

Check the last time of a table using the Check table or Myisamchk tool

15.Collation

Default character set and character collation for tables

16.Checksum

If enabled, the checksum is computed for the contents of the entire table
17.create_options

All other options when the table is created

18.Comment

Contains additional information for the MyISAM engine, which contains the comment Xu Peoni, if the table uses the InnoDB engine, the remaining space of the actual table. If it is a view, the comment contains the view typeface.

Mysql-show TABLE Status Command