USE information_schema;
SELECT table_name,table_rows FROM TABLES WHERE TABLE_SCHEMA = 'databasename' ORDER BY 
table_rows DESC;