Mysql データ量確認

MySQL

Posted at 2024-12-12

メモ用
mysqlでコピペして動作

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;

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up