How to get the size of a table?
Posted: Tue May 10, 2016 5:50 pm
Hello,
how do I get the size of a table in MB?
Is there a query you can use?
how do I get the size of a table in MB?
Is there a query you can use?
Code: Select all
SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB'
FROM information_schema.TABLES
WHERE table_schema = "$DB_NAME" AND table_name = "$TABLE_NAME";