Re: Table status for innodb tables show "innodb free" 2 times

2006-10-12 Thread Dominik Klein
Heikki thanks for filing that report. You can close it again. I had a look at the create-table statements for these 3 tables. As it turns out, the person who initially created those tables had a create statement like "create table ... comment='InnoDB free: 6144 kB'" for some tables. All my

Re: Table status for innodb tables show "innodb free" 2 times

2006-10-12 Thread Heikki Tuuri
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 regar

Re: Table status for innodb tables show "innodb free" 2 times

2006-10-12 Thread Dominik Klein
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. -- MySQL General Mailing List For

Re: Table status for innodb tables show "innodb free" 2 times

2006-10-12 Thread Heikki Tuuri
Dominik, what does SHOW TABLE STATUS show for other tables? Are you using innodb_file_per_table? 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 table