Get total size of all MySQL databases on a server

SELECT table_schema, sum( data_length + index_length )/1024/1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;

MySQL

Comments 1