Bug #11353 Create indices after bulk insert

• Submitted: 15 Jun 2005 14:17
• Modified: 15 Oct 2009 5:52
• Reporter: Niklas Johansson
• Status: Won't fix
• Category: MySQL Migration Toolkit
• Severity: S4 (Feature request)
• Version: 1.1.16
• OS: Any
• CPU Architecture: Any
• Tags: CHECKED

[15 Jun 2005 14:17] Niklas Johansson

Description:
As a way to improve performance the migration tool should create the indices after the data has been transfered and not when the tables are crated.

How to repeat:
Try to transfer a table with a lot of rows and a couple of indices.

[11 Feb 2009 13:50] Susanne Ebrecht

Many thanks for pointing this out.

Creating indexes after you filled the tables is not a good idea in MySQL either.

But disable/enable keys would be a good idea.

We will think about it.

[15 Oct 2009 5:52] Susanne Ebrecht

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Migration Tool into MySQL Workbench. We won't add this feature request anymore.

In MySQL Workbench we overworked SQL output.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/