MySQL Show Database Used and Free Size #tags: MySQL

query.sql

-- Query 1
SELECT 
	sum(round(((data_length + index_length) / 1024 / 1024 / 1024), 2)) as "Size in GB"
FROM 
	information_schema.TABLES
WHERE 
	table_schema = "ods"

-- Query 2
SELECT 
	table_schema "database name",
    sum( data_length + index_length ) / 1024 / 1024 "database size in MB",
    sum( data_free )/ 1024 / 1024 "free space in MB"
FROM 
	information_schema.TABLES
GROUP BY 
	table_schema;