Shulou(Shulou.com)05/31 Report--

This article is about how to use show table status in MySQL. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

-- get the information of the table

Mysql > show table status like 'columns_priv'\ G

* * 1. Row *

Name: columns_priv

Engine: MyISAM

Version: 10

Row_format: Fixed

Rows: 0

Avg_row_length: 0

Data_length: 0

Max_data_length: 227994731135631359

Index_length: 4096

Data_free: 0

Auto_increment: NULL

Create_time: 2016-12-13 18:59:06

Update_time: 2016-12-13 18:59:06

Check_time: NULL

Collation: utf8_bin

Checksum: NULL

Create_options:

Comment: Column privileges

_ _

Description of the function of parameters:

1.Name

Table name

2.Engine:

Storage engine for the table. In the old version, it was called Type, not Engine

3.Version:

Version

4.Row_format

Line format. For MyISAM engines, this could be Dynamic,Fixed or Compressed. Dynamic rows have variable row lengths, such as Varchar or Blob type fields. A fixed row means that the length of the row is constant, such as fields of type Char and Integer. The rows of Compressed exist only in the compressed table

5. Rows

The number of rows in the table. For MyISAM and other storage engines, this value is accurate, and for transactional engines (innodb), it is usually estimated.

6.Avg_row_length

Average number of bytes per line

7.Data_length

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

8.Max_data_length

The maximum amount of data that a table can hold

9.Index_length

The amount of space occupied by the index on the disk

10.Data_free

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

11.Auto_increment

Value of the next Auto_increment

12.Create_time

Creation time of the table

13.Update_time

Last updated time of the table

14.Check_time

Use the check table or myisamchk tool to check the most recent time of the table

15.Collation

Default character set and character collation for the table

16.Checksum

If enabled, the checksum when calculating the contents of the entire table

17.Create_options

Refers to all other options when the table is created

18.Comment

Contains other additional information, for the MyISAM engine, includes the comment Xu Bioxin, if the table is using the innodb engine, the remaining space of the table will be realised. If it is a view, the comment contains the word VIEW.

Thank you for reading! This is the end of the article on "how to use show table status in MySQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.