check space of databases using mysql query

select table_schema, sum((data_length+index_length)) AS BYTES from information_schema.tables group by 1;