Mysql management commands

MysqlshowtablestatuslikemytableG; ***************************** 1. row ************************** Name: mytable table Name Engine: innoDB Storage engine InnoDBVersion: 10mysql Row_format: Compact row format. Formats include Dynamic, fixed, and Compact. D

Mysql show table status like mytable \ G; ***************************** 1. row ************************** Name: mytable table Name Engine: innoDB Storage cited by Qingwei InnoDB Version: 10 mysql Version Row_format: Compact row format. Formats include Dynamic, fixed, and Compact. D

Mysql> show table status like 'mytable' \ G;

* *************************** 1. row ***************************

Name: mytable table Name

Engine: InnoDB Storage Engine Qingwei InnoDB

Version: 10 mysql Version

Row_format: Compact row format. Formats include Dynamic, fixed, and Compact. Dynamic is a Dynamic row. The variable length fields such as baohang varchar and BloB are included in the table fields. Fixed is a fixed-length row. Compact is row compression.

Rows: number of Rows in Table 0

Avg_row_length: 0 average number of bytes per line

Data_length: 16384 data size of the entire table (in bytes)

Max_data_length: the maximum capacity of the 0 table. 0 indicates Unlimited

Index_length: 0 size of disk space occupied by index data

Data_free: 10485760 indicates the size of the allocated but not used space.

Auto_increment: NULL Value of the next AUto_increment

Create_time: 22:39:46 Creation Time

Update_time: NULL Update Time

Check_time: The check time when NULL uses the check table command.

Collation: utf8_general_ci default Character Set and character column arrangement order

Checksum: NULL indicates the Checksum of the entire table if it is started.

Create_options: max_rows = 4294967295 avg_row_length = 32 Table creation options

Comment:

1 row in set (0.00 sec)

Original article address: mysql management commands. Thank you for sharing them.