List your MySQL Tables According to Size or Row Count

USE INFORMATION_SCHEMA;
 
SELECT table_name,table_rows,data_length 
FROM TABLES where table_schema = 'DBNAME' 
ORDER BY data_length DESC

source: $link[host]