Get table sizes from MySQL

mysql-table-sizes.sql

select table_schema as 'schema',
table_name as 'table',
round(((data_length + index_length) / 1024 / 1024 / 1024), 0) 'gigs',
round((data_length + index_length) /
    (select sum(data_length + index_length)
    from information_schema.tables) * 100, 0) 'percent'
from information_schema.tables
order by (data_length + index_length) desc;