List MySQL tables, their respective row count and size.

mysql_table_stats.sql

SELECT 
    table_name AS `Table`,
    table_rows AS `Row Count`,
    ROUND(data_length + index_length) AS `Size (Bytes)`,
    CASE
        WHEN data_length + index_length < 1024 THEN CONCAT(ROUND((data_length + index_length), 2), ' B')
        WHEN data_length + index_length < 1024 * 1024 THEN CONCAT(ROUND((data_length + index_length) / 1024, 2), ' KB')
        WHEN data_length + index_length < 1024 * 1024 * 1024 THEN CONCAT(ROUND((data_length + index_length) / 1024 / 1024, 2), ' MB')
        WHEN data_length + index_length < 1024 * 1024 * 1024 * 1024 THEN CONCAT(ROUND((data_length + index_length) / 1024 / 1024 / 1024, 2), ' GB')
        ELSE CONCAT(ROUND((data_length + index_length) / 1024 / 1024 / 1024 / 1024, 2), ' TB')
    END AS `Size`,
    ROUND((data_length + index_length) / total_db_size * 100, 2) AS `Size (%)`
FROM 
    information_schema.tables,
    (SELECT SUM(data_length + index_length) AS total_db_size
     FROM information_schema.tables
     WHERE table_schema = 'your_database_name') AS db_size
WHERE 
    table_schema = 'your_database_name'
ORDER BY 
    (data_length + index_length) DESC;