Top 10 largest tables in a MySQL database

largest-tables-in-mysql.sql

-- Top 10 largest tables in a MySQL database
-- MySQL 5.7.29

SELECT 
    table_schema AS `Database`,
    table_name AS `Table`,
    ROUND((data_length + index_length) / 1024 / 1024, 2) AS `Size (MB)`,
    ROUND(data_length / 1024 / 1024, 2) AS `Data Size (MB)`,
    ROUND(index_length / 1024 / 1024, 2) AS `Index Size (MB)`,
    table_rows as 'Rows'
FROM 
    information_schema.tables
WHERE
--     table_schema = 'my_database' AND table_type = 'BASE TABLE'
--     table_type = 'BASE TABLE'
    table_schema NOT IN ('mysql', 'information_schema', 'performance_schema', 'sys')
ORDER BY 
    (data_length + index_length) DESC
LIMIT 10;