Monday, August 11, 2014

How to calculate the DB Size of MYSQL

SELECT table_schema "Database Name"
     , SUM(data_length + index_length) / (1024 * 1024) "Database Size in MB"
FROM information_schema.TABLES
GROUP BY table_schema


No comments:

Post a Comment