Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2011

    Unanswered: How to get rid of tail 'InnoDB free: 8192 kB' in table comment?

    When I create table it's comment is set to "InnoDB free: 8192 kB".
    If I define comment that text is appended to what I defined.
    Can I get rid of it ?

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain

    with what tool are you looking at the comment information? I have seen something similar in the past but the issue was related to the GUI tool that was being used rather than the data in the table itself.

    Check out this link
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

  3. #3
    Join Date
    Jan 2011
    Here is a sequence of queries I've made.
    My tool just uses jdbc.
    But to make sure I made the last query by Java code.

    create database myschema;
    create table myschema.mytable (id int);
    alter table myschema.mytable comment = 'qwe';
    select TABLE_COMMENT from information_schema.TABLES
    where TABLES.TABLE_SCHEMA = 'myschema' and TABLES.TABLE_NAME = 'mytable';
    The result is
    qwe; InnoDB free: 8192 kB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts