MySQL Size of Databases and Tables

size_of_databases.sql

SELECT
  table_schema AS "Database",
  ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (GB)"
FROM
  information_schema.TABLES
GROUP BY
  table_schema;

size_of_tables.sql

SELECT
  table_name AS "Table",
  ROUND(
    (
      (data_length + index_length) / 1024 / 1024 / 1024
    ),
    2
  ) AS "Size (GB)"
FROM
  information_schema.TABLES
WHERE
  table_schema = "my_database"
ORDER BY
  (data_length + index_length) DESC;