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/