A neat script for retrieving database size in MB. I found it useful for checking on Amazon RDS instances.
SELECT table_schema "Database", SUM( data_length + index_length) / 1024 / 1024 "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema ;
No comments:
Post a Comment