SEO

#1 (**permalink**) 02-27-2008, 09:32 PM

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.

#2 (**permalink**) 02-27-2008, 09:32 PM

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 (well, his, I did not create these tables ... ) fault, sorry to
have wasted your time.

Regards
Dominik

Heikki Tuuri schrieb:
> 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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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