MySQL: to find largest tables

 

select table_schema as database_name,

       table_name,

       round( (data_length + index_length) / 1024 / 1024, 2)  as total_size,

       round( (data_length) / 1024 / 1024, 2)  as data_size,

       round( (index_length) / 1024 / 1024, 2)  as index_size

from information_schema.tables

where table_schema not in ('information_schema', 'mysql',

                           'performance_schema' ,'sys')

      and table_type = 'BASE TABLE'

      -- and table_schema = 'your database name'

order by total_size desc

limit 10;