MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: load data infile performance Advice, help wanted urgently
Posted by: Charles Yu
Date: April 15, 2008 11:24AM

Hi Mark,

Many thanks for your helpful advice. By adjusting innodb_log_file_size from 128M to 1G, and having PK/index attached to the table, the entire loading together with indexing finished in 60 minutes, at leas about 3 times faster than before.

In some other tests, I also tried to double innodb_buffer_pool_size to 1G, but this parameter setting change didn't seem to make any significant difference.

As for mysql upgrade from 5.0.3x to 5.0.5x, I yet further work on that later.

Thanks and regards,
Charles Yu

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
load data infile performance Advice, help wanted urgently
4701
Charles Yu
April 09, 2008 12:23PM
Re: load data infile performance Advice, help wanted urgently
2109
Mark Callaghan
April 13, 2008 12:11PM
Re: load data infile performance Advice, help wanted urgently
1950
Charles Yu
April 15, 2008 11:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.