MySQL查看数据库表容量大小

table_schema as ‘ smartxs ‘ , sum (table_rows) as ‘ 记录数 ‘ , sum ( truncate (data_length / 1024 / 1024 , 2 )) as ‘ 数据容量(MB) ‘ , sum ( truncate (index_length / 1024 / 1024 , 2 )) as ‘ 索引容量(MB) ‘ from information_schema.tables group by table_schema order by sum (data_length) desc , sum (index_length) desc ;

2.查看所有数据库各表容量大小

 select  table_schema  as   ‘  数据库  ‘  ,
table_name   as   ‘  表名  ‘  ,
table_rows   as   ‘  记录数  ‘  
,  truncate (data_length /  1024  /  1024 ,  2 )  as   ‘  数据容量(MB)  ‘  
,  truncate (index_length /  1024  /  1024 ,  2 )  as   ‘  索引容量(MB)  ‘ 
 from   information_schema.tables 
  where  table_schema =  ‘  请修改要查看的数据库名称  ‘ 
 order   by  data_length  desc , index_length  desc ;

 

MySQL查看数据库表容量大小

标签：style   rtx   for   format   ble   tables   修改   容量   tab   

查看更多关于MySQL查看数据库表容量大小的详细内容...