[MySQL]DBの容量確認

LINEで送る
Pocket

SELECT 
    table_schema, sum(data_length) /1024/1024 AS mb 
FROM 
    information_schema.tables  
GROUP BY 
    table_schema 
ORDER BY       
    sum(data_length+index_length) DESC;

 

Was this helpful?

0 / 0

コメントを残す 0

Your email address will not be published. Required fields are marked *