[ale] Convert MyISAM table to InnoDB takes forever - Solved

Brandon Checketts brandon at brandonchecketts.com
Tue Aug 25 17:36:09 EDT 2009


In this case, I just dumped the table with mysqldump from the InnoDB
table that took forever to create.   It appeared to be ordered at first
glance.   Upon closer examination, I see that it is not perfectly
ordered, but it is fairly close.   Enough to have improved the insert
performance dramatically.

Thanks,
Brandon Checketts

Richard Bronosky wrote:
> Curious. How did you "reordered my data and populated the table using
> that"? Specifically the reordering your data.
> 
> On Tue, Aug 25, 2009 at 1:44 PM, Brandon
> Checketts<brandon at brandonchecketts.com> wrote:
>> reordered my data and populated the table using that
> 
> 
> 


More information about the Ale mailing list