Show Table status in Mysql method to get table information _mysql

Source: Internet
Author: User

How to use

Mysql>show table status;
Mysql>show table status like ' Esf_seller_history ' \g;
Mysql>show table status like ' esf_% ' \g;

Sample Example:

Mysql>show table status like ' Esf_seller_history ' \g;

1.Name

Table name

2.Engine:

Table's Storage Engine

3.Version:

Version

4.row_format

Row format. For MyISAM engines, this could be dynamic,fixed or compressed. The length of a dynamic row is variable, such as a varchar or blob type field. Fixed rows are the same length of rows, such as char and integer type fields.

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 line included

7.data_length

Amount of data in the entire table (in bytes)

8.max_data_length

Maximum amount of data that a table can hold

9.index_length

Index occupies disk space size

10.data_free

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

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

To check the most recent time of a table using the check table or the Myisamchk tool

15.Collation

Default character set and character collation for tables

16.Checksum

If enabled, the checksum for the contents of the entire table is calculated

17.create_options

All other options when the table is created

18.Comment

Contains additional information, for the MyISAM engine, contains annotation Xu Peoni, if the table is using the InnoDB engine, the remaining space of the reality table. If it is a

View, and the comment contains the word view.

The above content is small to introduce the MySQL Show table status Get table information method, I hope to help!

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.