当前位置：网站首页>MySQL query library size

MySQL query library size

2022-04-23 15:14:00 【A run】

Reference resources ：MySQL View the database table size _ Aoxue Xingfeng -CSDN Blog _mysql Check the table size

select 
table_schema as ' database ',
sum(table_rows) as ' Record number ',
sum(truncate(data_length/1024/1024, 2)) as ' Data capacity (MB)',
sum(truncate(index_length/1024/1024, 2)) as ' Index capacity (MB)'
from information_schema.tables
group by table_schema
order by sum(data_length) desc, sum(index_length) desc;

版权声明
本文为[A run]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204231407312563.html