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"
)
No comments:
Post a Comment