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