Showtablestatuslike & #39; table & #39; \ G details
Mysql> show table status like 'leyangjun' \ G
* *************************** 1. row ***************************
Name: leyangjun table Name
Engine: MyISAM Table Storage Engine
Version: Version 10
Row_format: Dynamic row format
Rows: number of Rows in Table 3999999 (accurate for non-transactional tables)
Avg_row_length: 31 average number of bytes contained in each row
Data_length: 127995956 data volume of the entire table (calculated in bytes)
Max_data_length: 281474976710655 maximum table capacity
Index_length: 41114624 size of disk space occupied by index data
Data_free: 0 for myisam tables, it indicates space allocated but not used
Auto_increment: 4000001 next Auto_increment Value
Create_time: 14:17:37 time when the table was initially created
Update_time: 14:25:07 the time when the table data was last updated
Check_time: NULL use the check table command or myisamchk tool to check the latest check time
Collation: Default Character Set and character column sorting rules in the utf8_general_ci table
Checksum: If NULL is enabled, real-time checksum is calculated for the content of the entire table.
Create_options: all other options for table Creation
Comment: This field contains additional information,
1 row in set (0.00 sec)