/* Size of ALL Table Schemas in GB and MB */ SELECT round(sum(((data_length + index_length)/1024/1024/1024)),2) GB, round(sum(((data_length + index_length)/1024/1024)),2) MB FROM information_schema.TABLES; /* Size of ALL Table Schemas Ordered by Table Schema Name */ SELECT TABLE_SCHEMA, TABLE_NAME, round(((data_length + index_length)/1024/1024/1024),2) GB, round(((data_length + index_length)/1024/1024),2) MB FROM information_schema.TABLES ORDER BY TABLE_SCHEMA, TABLE_NAME; /* You can also filter on Database (Table_Schema) Name, Order by Size, etc */