Geek Answers Handbook

How to disable MySQL comments for InnoDB using foreign keys?

For some time, I noticed that MySQL will add comments to InnoDB tables that have foreign keys. It looks like this:

InnoDB free: 0 kB; ( event_id ) REFER events ( event_id ) ON U...

To correctly display my description of the table, I have to parse the line and break it with a semicolon. This is generally unimportant, but it is very unpleasant to see this message in the database GUI.

I went through stackoverflow and found this question , which was not very convenient in my case, so I'm wandering, is it possible to disable this behavior / error?

UPDATE: the version of MySQL installed on the servers of the hosting provider is 5.0.77

+6
comments mysql foreign-keys innodb
source share
1 answer

I found this question in the official MySQL forum. MySQL engineers seem to know the problem, but do not fix it. http://forums.mysql.com/read.php?22,49710,49710#msg-49710

I'm not sure that I am able to discuss a change in the InnoDB storage engine, however, if you ask me as a user and MySQL developer I would say: yes, change this as soon as you can. Free space information is not in the table comment ... Mike Lischek, Senior Software Engineer Developer Tools MySQL Corporation, www.oracle.com ..

-

some applications will break when we move the information from the comment to Data_free. And users will need to learn a new way to test free space. Therefore, a change could take place in the new major version. Heikki Oracle Corp./Innobase Oy InnoDB - Transactions, Row-Level Locking and Foreign Keys for MySQL

+1
source share

More articles:


All Articles