List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 3 1999 11:27am
Subject:Re: Recovery/Import Loading Speed
View as plain text  
At 3:15 AM -0500 9/3/99, Joshua Chamas wrote:
>Hey,
>
>In case of disaster, I would like to have all my tables
>backed up in the form of an export, which I would be
>able to later import.  What's faster, creating a table
>with its indexes, then import, or create/import and
>add indexes later.
>
>With Oracle, it was always recommended to create
>an index on the table after a large table import, but
>MySQL might be different ?  I'm talking about a table
>on the order of a 1 gig, so a difference of 50%
>might shave off a few hours of downtime if I should
>need this form of recovery.

It's the same for MySQL; create the indexes after importing
your data.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
Recovery/Import Loading SpeedJoshua Chamas3 Sep
  • Re: Recovery/Import Loading SpeedPaul DuBois3 Sep
  • Re: Recovery/Import Loading Speedsinisa3 Sep