Re:SHOW STATUS / COUNT(*) Innobase table.

[Heikki Tuuri]

Alex,

yes, SHOW TABLE STATUS returns only approximate statistics about the
row count for Innobase tables. These statistics are used in the SQL
optimization. 

From section 8.7 in the MySQL manual:

...........<snip>............

SHOW TABLE STATUS FROM TEST LIKE 'CUSTOMER'

if you have created a table of name CUSTOMER in a database you have named
TEST. Note that the statistics SHOW gives about Innobase tables are
only approximate: they are used in SQL optimization. Table and index
reserved sizes in bytes are accurate, though. 

...........<snip>.............

Regards,

Heikki

>Bonjour,

>  I have a table with 111619 rows in it.

>  "show  table  status"  and  "select  count(*)" don't return the same
>  number of rows.

>  Is this know ?


>  Regards,
>  Alex.