Count rows sql

SELECT SUM(TABLE_ROWS)
     FROM INFORMATION_SCHEMA.TABLES
     WHERE TABLE_SCHEMA = '{your_db}';


https://www.percona.com/blog/2008/02/04/finding-out-largest-tables-on-mysql-server/