List up large database tables in MySQL / MariaDB

list_all_database_sizes.sql

-- All databases.
SELECT
  table_schema AS `Database`, 
  ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS `Size in MB` 
FROM information_schema.tables 
GROUP BY `Database`
ORDER BY `Size in MB` DESC;

list_large_tables.sql

-- See: https://stackoverflow.com/questions/9620198/how-to-get-the-sizes-of-the-tables-of-a-mysql-database
-- Largest 10 tables.
SELECT
  table_schema AS `Database`,
  table_name AS `Table`,
  round(((data_length + index_length) / 1024 / 1024), 2) AS `Size in MB`
FROM information_schema.TABLES
ORDER BY `Size in MB` DESC
LIMIT 10;