select 
  table_schema, 
  table_name, 
  round(sum(data_length + index_length)/1024/1024, 2) as tblsizeMB 
from information_schema.tables 
group by table_schema,table_name 
order by tblsizeMB desc limit 50

select 
  table_schema, 
  table_name, 
  round(sum(data_length + index_length)/1024/1024/1024, 2) as tblsizeGB 
from information_schema.tables 
group by table_schema,table_name 
order by tblsizeGB desc limit 50

Last updated 2 May 2024