Get total size of all MySQL databases on a server

SELECT table_schema, sum( data_length + index_length )/1024/1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;

Source

Leave a Reply

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

Markdown is allowed in comments.