Size of all databases

gistfile1.sql

SELECT table_schema,
     CONCAT(ROUND(sum(table_rows) / 1000000, 2), 'M')                                    rows,
     CONCAT(ROUND(sum(data_length) / ( 1024 * 1024 * 1024 ), 2), 'G')                    DATA,
     CONCAT(ROUND(sum(index_length) / ( 1024 * 1024 * 1024 ), 2), 'G')                   idx,
     CONCAT(ROUND(( sum(data_length) + sum(index_length) ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
     ROUND(sum(index_length) / sum(data_length), 2)                                           idxfrac
FROM   information_schema.TABLES
group by table_schema
ORDER  BY data_length + index_length DESC