Uncategorized

Mysql: Table size query

 

 

SELECT
TABLE_NAME,
table_rows,
data_length,
index_length,
ROUND(((data_length + index_length) / 1024 / 1024),2) ‘Size in MB’
FROM
information_schema.TABLES
WHERE
table_schema = ‘mallagroup_mautic’

ORDER BY ROUND(((data_length + index_length) / 1024 / 1024),2) DESC
;

Leave a Reply

Your email address will not be published. Required fields are marked *