SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema = 'dbName';
select sum(t.table_rows) from (select table_name,table_rows from information_schema.tables where TABLE_SCHEMA = 'dbName' order by table_rows asc) t;
SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema = 'dbName';
select sum(t.table_rows) from (select table_name,table_rows from information_schema.tables where TABLE_SCHEMA = 'dbName' order by table_rows asc) t;