Bases de datos

Conectado desde la consola de MariaDB o Mysql en una BD concreta, ejemplo 'MiBaseDeDatos'

MariaDB [MiBaseDeDatos]> 

Lanzamos la consulta:

SELECT       table_schema as `Database`,       table_name AS `Table`,       round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`  FROM information_schema.TABLES  ORDER BY (data_length + index_length) DESC;                     

La salida será algo similar a esto: 

Espacio ocupado en GB

select table_schema "DB name (table_schema)", sum((data_length+index_length)/1024/1024/1024) AS "DB size in GB" from information_schema.tables group by table_schema;

Espacio ocupado en MB y espacio disponible

SELECT table_schema "database name", sum( data_length + index_length ) / 1024 / 1024 "database size in MB", sum( data_free )/ 1024 / 1024 "free reclaimable space in MB" FROM information_schema.TABLES GROUP BY table_schema;

Referencias