Thanks everyone for the responses. Will put me on the right track
here..something that was rolling through my head but I couldn't really
define. I will be blogging about this later as I think it is fairly
important, but often not understood by beginning/mid-level dbas.
thank again,
Keith
W
At 02:05 PM 11/16/2007, you wrote:
How do you import the data?
Load data from file is faster thought
so better to export myisam -> file and then you do load data from file
make sure you set autocommit=0 to make it faster
Ady,
Sure but won't the entire Load Data will still be wrapped in a
How do you import the data?
Load data from file is faster thought
so better to export myisam -> file and then you do load data from file
make sure you set autocommit=0 to make it faster
On Nov 17, 2007 12:29 AM, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
> I have something to throw out. I just
Use smaller transactions that don't have 140 million rows. When attempting an
action with important data, make sure you can survive the actions failure. If
you can't, then you need to think of a different way of doing it that will
allow a recoverable failure.
- Original Message
From:
