Re: Show table status query

[Stefan Hinz]

Daniel Kasak wrote:
Andrew Barnes wrote:
When I run the SHOW TABLE STATUS query against a database with 4 
tables, 3
of the tables come have the correct row count, but 1 table changes the 
No of
rows every time I run the query. The correct row count for this table is
313, but the query returns anywhere from 97 to 574. I am running 
4.0.13 on
MAC OS/X 10.3 and the table is an INNODB table.

Has anybody else ever seen this?
Regards
Andy
 

Yes that's normal behaviour for an InnoDB table.
It's in the docs somewhere.
Note that the statistics SHOW gives about InnoDB tables are only 
approximate. They are used in SQL optimization. Table and index reserved 
sizes in bytes are accurate, though.

http://dev.mysql.com/doc/mysql/en/Using_InnoDB_tables.html
Regards,
Stefan Hinz
--
Stefan Hinz [EMAIL PROTECTED]
iConnect e-commerce solutions GmbH
Taunusstr. 27, 12161 Berlin, Germany
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Show table status query

[Daniel Kasak]

Andrew Barnes wrote:
Hi
When I run the SHOW TABLE STATUS query against a database with 4 tables, 3
of the tables come have the correct row count, but 1 table changes the No of
rows every time I run the query. The correct row count for this table is
313, but the query returns anywhere from 97 to 574. I am running 4.0.13 on
MAC OS/X 10.3 and the table is an INNODB table.
Has anybody else ever seen this?
Regards
Andy
 

Yes that's normal behaviour for an InnoDB table.
It's in the docs somewhere.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]