Re: Exact table count for all tables in a schema.

[Peter Brawley]

It's a transactional engine, so at any moment "exact row count" depends on what's happening inside transactions.

-- InnoDB lastest estimate ...
select table_rows
from information_schema.tables
where table_schema="..." and table_name="...";

-- Count from index ...
select count(1) from ...;