Database Size Estimation Queries

db_size.sql

-- Display size of all databases in a MySQL server
SELECT table_schema AS 'Database Name',
       sum(data_length + index_length) AS 'Size in Bytes',
       round((sum(data_length + index_length) / 1024 / 1024), 4) AS 'Size in MB'
FROM information_schema.TABLES
WHERE table_schema NOT IN ('information_schema',
                           'performance_schema',
                           'mysql',
                           'sys')
GROUP BY table_schema
ORDER BY sum(data_length + index_length) DESC;


 
 -- Display size of tables in a database
SELECT TABLE_NAME,
       table_rows,
       data_length,
       index_length,
       round(((data_length + index_length) / 1024 / 1024),2) "Size"
FROM information_schema.TABLES
WHERE table_schema = "discus";