Query statement: Replace `database` with your own database name
select
table_schema as 'Database',
table_name as 'Table Name',
table_rows as 'Row Count',
truncate(data_length/1024/1024, 2) as 'Data Size (MB)',
truncate(index_length/1024/1024, 2) as 'Index Size (MB)'
from information_schema.tables
where table_schema='database'
order by data_length desc, index_length desc;
SQL Attachment https://www.cnop.net/uploadfile/2020/0311/20200311030641987.zip