How to Get the Size of a Table in MySQL

SELECT
    TABLE_NAME AS `Table`,
    ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS `Size (MB)`
FROM
    information_schema.TABLES
WHERE
    TABLE_SCHEMA = 'DatabaseName'
ORDER BY
    (DATA_LENGTH + INDEX_LENGTH)
DESC;

資料來源：https://chartio.com/resources/tutorials/how-to-get-the-size-of-a-table-in-mysql/