Get size of MySQL database using SELECT statement

Use this MySQL to get size of database:

 

SELECT table_schema "DatabaseName", SUM(index_length+data_length)/1024/1024 "DatabaseSizeMB" FROM information_schema.TABLES GROUP BY table_schema;

 

 

Published by

Henrik Damgaard

Hi I’m Henrik and I write this blog based on useful topics I find interesting – mostly covering some of my technical interests : System Center Operations Manager (SCOM), BizTalk, Windows Server, PowerShell, SQL server, Internet Information Services, PHP and .NET I am currently holding a position as System Administrator with focus on Microsoft server products.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.