DeveloperBreeze

Data Length Development Tutorials, Guides & Insights

Unlock 1+ expert-curated data length tutorials, real-world code snippets, and modern dev strategies. From fundamentals to advanced topics, boost your data length skills on DeveloperBreeze.

Viewing the Database Size and Identifying the Largest Table in MySQL

Tutorial August 12, 2024
mysql 

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.

Read More