USE information_schema;

SELECT table_name,table_rows 
FROM tables

WHERE TABLE_SCHEMA = 'testdb'

ORDER BY table_rows DESC;