MySQL Bugs: #31549: MA stores "InnoDB Free" information to "Comments" when you edit a table

Bug #31549	MA stores "InnoDB Free" information to "Comments" when you edit a table
Submitted:	11 Oct 2007 21:54	Modified:	13 Feb 2009 14:04
Reporter:	Chris Calender	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	All	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	comments, innodb free, InnoDB Free stored

Description:
When you edit a table within MA, it always appends and *stores* the "InnoDB Free" information to the "Comment" field.

As this value is always changing (i.e., InnoDB Free), this should not be stored.

We do not store it when you dump a table structure (i.e., with SHOW CREATE TABLE), which is what is used for backups, so it should not be stored here.

It would be great if you displayed this information (as it is standard for InnoDB tables), but please do not store it.  It is of no value to store it.  At any point in the future, this value is obsolete, and it would never be used when you restore a table either, so I see no need for it.

How to repeat:
1. Create an InnoDB table
2. Edit the table with MA
3. Notice that the "comment" now has "InnoDB free ..." information stored there.

Suggested fix:
Please do not *store* this information.

This is similar/related to bug #31548 (but they are not quite the same).

http://bugs.mysql.com/bug.php?id=31548

re-verifying: You won't get this informations anymore in actual release: MySQL Administrator 1.2.16.

This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/