view statictic/ highlight/ summary of mysql database

mysql_engine_stats.sh

mysql -uroot

--
-- SHOW TABLES SIZE OF EACH DATABASES
--
SELECT 
     table_schema as `Database`, 
     table_name AS `Table`, 
     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM information_schema.TABLES 
WHERE table_schema<>'mysql' and table_schema<>'information_schema' and round(((data_length + index_length) / 1024 / 1024), 2) > 0
ORDER BY (data_length + index_length) DESC;

--
-- SHOW DATABASES SIZE
--
SELECT table_schema "DB Name", ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables GROUP BY table_schema; 

--
-- SHOW DATABASES AND THEIR NUMBER OF TABLES
--
select table_schema, count(1)
from information_schema.tables
WHERE table_schema<>'mysql' and table_schema<>'information_schema' and table_schema<>'performance_schema' 
group by table_schema;