How to obtain table information using showtablestatus in mysql (Figure)

This article describes how to obtain table information in showtablestatus in mysql (figure). It has some reference value. let's take a look at the usage method.

mysql>show table status;mysql>show table status like 'esf_seller_history'\G;mysql>show table status like 'esf_%'\G;

Example:

mysql>show table status like 'esf_seller_history'\G;

1. Name
   Table name
   2. Engine:
   Table Storage Engine
   3. Version:
   Version
   4. Row_format
   Row format. For the MyISAM engine, this may be Dynamic, Fixed, or Compressed. The row length of a dynamic row is variable, for example, a Varchar or Blob field. A fixed row means that the row length remains unchanged, for example, Char and Integer fields.
   5. Rows
   The number of rows in the table. For non-transactional tables, this value is accurate. for transactional engines, this value is usually estimated.
   6. Avg_row_length
   Average number of bytes per line
   7. Data_length
   Data volume of the entire table (unit: bytes)
   8. Max_data_length
   Maximum data size that a table can accommodate
   9. Index_length
   Disk space occupied by Indexes
   10. Data_free
   For the MyISAM engine, it identifies the allocated space that is not used now and contains the space of the deleted row.
   11. Auto_increment
   Value of the next Auto_increment
   12. Create_time
   Table creation time
   13. Update_time
   Last table update time
   14. Check_time
   Use the check table or myisamchk tool to check the latest time
   15. Collation
   Default character set and character sorting rules of a table
   16. Checksum
   If enabled, the checksum is calculated for the content of the entire table.
   17. Create_options
   All other options during table creation
   18. Comment
   Other additional information is included. for the MyISAM engine, note Xu Biao. if the table uses the innodb engine, the actual table space is left. For a VIEW, the comment contains the VIEW text.

The preceding section describes how to obtain table information using showtablestatus in mysql (figure). For more information, see PHP Chinese website (www.php1.cn )!