MySQL | Table and Database sizes

The SQL script below can list out the entire databases size
SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
Locating The MySQL Stored Data in the file-system can also help
/var/lib/mysql$ ls -lh

No comments:

Post a Comment