Ways to Get Table Row Counts in MySQL.

SELECT table_name,table_schema,table_rows
FROM information_schema.tables
WHERE table_schema not in('mysql','performance_schema','information_schema');