get size of mysql tables

Please login or create account to add a snippet.

Follow @TagMyCode

Language: Bash

Posted by: bejoy balan

Added: Apr 22, 2020 5:23 AM

Tags: size table tablesize

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