Posted On March 31, 2019

MySQL: List Database Size

kimconnect 0 comments
blog.KimConnect.com >> Database >> MySQL: List Database Size
SELECT table_schema "kimconnect",
       ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM information_schema.tables
GROUP BY table_schema;
# change the owner of the database to sa
ALTER AUTHORIZATION on DATABASE::{database_name} to sa

Leave a Reply

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

Related Post

MySQL on Localhost

Modern versions of MySQL is memory intensive; thus, it is a pre-requisite that an adequate…

Microsoft Dynamics Email Router Failed to Start

Symptoms Event Log: Item 1: highest correlating event ID 26234 #26234 - The Email Router…

SQL: Microsoft Dynamics – Rebuilding a Database View Named ‘FilteredContact’

Why? Update: currently, I'm unable to rebuild this complex view due to SQL constraints. Hence,…