Tutorials Programming Tutorials, Guides & Best Practices

SELECT table_schema AS "Database",
       ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)"
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
GROUP BY table_schema;

• information_schema.tables: This system table stores metadata about tables in all databases.
• table_schema: Represents the database name.
• data_length and index_length: Represent the size of the table data and indexes, respectively.
• ROUND(..., 2): Rounds the result to two decimal places for readability.
• GROUP BY table_schema: Groups results by database name to aggregate sizes.