Syntax
------ 
SHOW TABLE STATUS [{FROM | IN} db_name]
 [LIKE 'pattern' | WHERE expr]
 
Description
----------- 
 SHOW TABLE STATUS works like 
 SHOW TABLES, but provides more extensive information about
each non-TEMPORARY table.
 
The LIKE clause, if present on its own, indicates which
table names to
match. The WHERE and LIKE clauses can be given to select
rows using more general conditions, as discussed in Extended
SHOW.
 
The following information is returned:
 
Column | Description | 
 
Name | Table name. | 
 
Engine | Table storage engine. | 
 
Version | Version number from the table's .frm file. | 
 
Row_format | Row format (see InnoDB, Aria and MyISAM row
formats). | 
 
Rows | Number of rows in the table. Some engines, such as
XtraDB and InnoDB may store an estimate. | 
 
Avg_row_length | Average row length in the table. | 
 
Data_length | For InnoDB/XtraDB, the index size, in pages,
multiplied by the page size. For Aria and MyISAM, length of
the data file, in bytes. For MEMORY, the approximate
allocated memory. | 
 
Max_data_length | Maximum length of the data file, ie the
total number of bytes that could be stored in the table. Not
used in XtraDB and InnoDB. | 
 
Index_length | Length of the index file. | 
 
Data_free | Bytes allocated but unused. For InnoDB tables in
a shared tablespace, the free space of the shared tablespace
with small safety margin. An estimate in the case of
partitioned tables - see the PARTITIONS table. | 
 
Auto_increment | Next AUTO_INCREMENT value. | 
 
Create_time | Time the table was created. | 
 
Update_time | Time the table was last updated. On Windows,
the timestamp is not updated on update, so MyISAM values
will be inaccurate. In InnoDB, if shared tablespaces are
used, will be NULL, while buffering can also delay the
update, so the value will differ from the actual time of the
last UPDATE, INSERT or DELETE. | 
 
Check_time | Time the table was last checked. Not kept by
all storage engines, in which case will be NULL. | 
 
Collation | Character set and collation. | 
 
Checksum | Live checksum value, if any. | 
 
Create_options | Extra CREATE TABLE options. | 
 
Comment | Table comment provided when MariaDB created the
table. | 
 
Similar information can be found in the
information_schema.TABLES table as well as by using
mysqlshow:
 
mysqlshow --status db_name
 
Example
 
show table status\G
*************************** 1. row
***************************
 Name: bus_routes
 Engine: InnoDB
 Version: 10
 Row_format: Dynamic
 Rows: 5
 Avg_row_length: 3276
 Data_length: 16384
Max_data_length: 0
 Index_length: 0
 Data_free: 0
 Auto_increment: NULL
 Create_time: 2017-05-24 11:17:46
 Update_time: NULL
 Check_time: NULL
 Collation: latin1_swedish_ci
 Checksum: NULL
 Create_options: 
 Comment:
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/show-table-status/