Mysql-show TABLE Status Command

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.