GNU Info

(mysql.info)SHOW TABLE STATUS

---

Next: SHOW STATUS Prev: SHOW DATABASE INFO Up: SHOW

---

Enter node , (file) or (file)node

`SHOW TABLE STATUS'
...................

     SHOW TABLE STATUS [FROM db_name] [LIKE wild]

`SHOW TABLE STATUS' (new in Version 3.23) works likes `SHOW STATUS',
but provides a lot of information about each table. You can also get
this list using the `mysqlshow --status db_name' command.  The
following columns are returned:

*Column*               *Meaning*
`Name'                 Name of the table.
`Type'                 Type of table. Note: Table types.
`Row_format'           The row storage format (Fixed, Dynamic, or
                       Compressed).
`Rows'                 Number of rows.
`Avg_row_length'       Average row length.
`Data_length'          Length of the data file.
`Max_data_length'      Max length of the data file.
`Index_length'         Length of the index file.
`Data_free'            Number of allocated but not used bytes.
`Auto_increment'       Next autoincrement value.
`Create_time'          When the table was created.
`Update_time'          When the data file was last updated.
`Check_time'           When the table was last checked.
`Create_options'       Extra options used with `CREATE TABLE'.
`Comment'              The comment used when creating the table (or some
                       information why MySQL couldn't access the table
                       information).

`InnoDB' tables will report the free space in the tablespace in the
table comment.