3 messages in com.mysql.lists.mysqlShow table status query
FromSent OnAttachments
Andrew Barnes17 May 2004 20:28 
Daniel Kasak17 May 2004 21:10 
Stefan Hinz18 May 2004 02:07 
Subject:Show table status query
From:Andrew Barnes (an@geni.com.au)
Date:05/17/2004 08:28:30 PM
List:com.mysql.lists.mysql

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