My mistake, easier than I thought:
Quote:
`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.