How to Calculate the size of DataBase using mysql or schema? Ans:- Query in mysql SELECT s.schema_name, CONCAT( IFNULL( ROUND( SUM( t.data_length ) /1024 /1024, 2 ) , 0.00 ) , "Mb" ) AS Data_size, CONCAT( IFNULL( ROUND( SUM( t.index_length ) /1024 /1024, 2 ) , 0.00 ) , "Mb" ) AS Index_size, COUNT( table_name ) total_tables FROM INFORMATION_SCHEMA.SCHEMATA s LEFT JOIN INFORMATION_SCHEMA.TABLES t ON s.schema_name = t.table_schema WHERE s.schema_name NOT IN ( "mysql", "information_schema", "test" )
