Space occupied by each table in the MySQL database

If you want to know the space occupied by each table in the MySQL database and the number of rows recorded in the table, you can open the information_schema database of MySQL. There is a TABLES Table in this database. The main fields of this table are:
TABLE_SCHEMA: Database Name
TABLE_NAME: Table Name
ENGINE: The storage ENGINE used
TABLES_ROWS: number of records
DATA_LENGTH: data size
INDEX_LENGTH: Index size
For other fields, see the MySQL manual. We only need to know these fields.
Therefore, you need to know the size of the space occupied by a table, which is equivalent to the data size + index size.
SQL:
SELECT TABLE_NAME, DATA_LENGTH + INDEX_LENGTH, TABLE_ROWS from tables where TABLE_SCHEMA = 'database name' AND TABLE_NAME = 'table name'

Author "yute"