From: Date: October 12 2006 2:14pm Subject: Re: Table status for innodb tables show "innodb free" 2 times List-Archive: http://lists.mysql.com/mysql/202575 Message-Id: <452E31B0.4080909@oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Dominik, I have now filed: http://bugs.mysql.com/bug.php?id=23211 about this. Is there any pattern that could explain why the double print is only in those 3 tables? What values does it print for the tables where the printout is wrong, and what values does it print for ok tables? Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Heikki Tuuri wrote: > FYI: > > http://lists.mysql.com/mysql/202574 > > > what does SHOW TABLE STATUS show for other tables? > > It shows 2 values for about 3 of 260 tables. So most tables are okay. It > does not seem to depend on table size, as the other tables only have a > few hundred rows. > > > Are you using innodb_file_per_table? > > Yes.