fast data loading??

[Jamar]

hello, I wish to load 8GB data each night into several innodb tables. What would be the fastest way to load the data? The table will be "hand-partitioned. Any suggestions, plz?
thank you! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Saggie]

Try to load data to one table at a time, possibly sorted on the primary key.
and also make the buffer pool as big as you can, and make the ib_logfiles big. hope that will solve the purpose! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --