[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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
> 
> 
>