Como ver las tablas más grandes

Es query nos da información de cuáles tablas son mas grandes en nuestra base de datos.

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;