#!/bin/bash

#------------------------------------------------------------------------------#
echo "
SELECT 
        table_schema AS 'Datenbankname',
        table_name,
        ROUND( DATA_LENGTH / 1024 / 1024, 3 ) AS 'Daten (MB)',
        ROUND( INDEX_LENGTH / 1024 / 1024, 3 ) AS 'Index (MB)',
        ROUND( DATA_FREE / 1024 / 1024, 3 ) AS 'Freier Speicher (MB)'
FROM
        information_schema.tables
WHERE
        TABLE_TYPE='BASE TABLE'
        AND
        ENGINE='InnoDB'
        AND
        TABLE_SCHEMA<>'mysql'
        AND
        TABLE_SCHEMA<>'sys'
ORDER BY 3
;" | mysql -t

#------------------------------------------------------------------------------#