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]