Bug #76725 No space reclaim after Alter Table TableName Engine = InnoDb

• Submitted: 16 Apr 2015 18:10
• Modified: 17 Apr 2015 10:29
• Reporter: Yudhveer Kandukuri
• Status: Not a Bug
• Category: MySQL Workbench
• Severity: S5 (Performance)
• Version: 6.3.1
• OS: Windows (Microsoft Windows 7 Enterprise Service Pack 1)
• CPU Architecture: Any
• Tags: WBBugReporter

[16 Apr 2015 18:10] Yudhveer Kandukuri

Description:
Hi,

After running the "Alter Table TableName Engine = InnoDb" there is no change in the reduction of size in Table_length and Index_length.

Also, my Innodb_file per table is enabled.

For some tables, the index length got increased.

Can you please explain me what could be the reason.

I am new to the MYSQL.

How to repeat:
Hi,

After running the "Alter Table TableName Engine = InnoDb" there is no change in the reduction of size in Table_length and Index_length.

Also, my Innodb_file per table is enabled.

For some tables, the index length got increased.

Can you please explain me what could be the reason.

I am new to the MYSQL.

[17 Apr 2015 10:29] MySQL Verification Team

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.