Re: Bad performance when migrating data
Posted by:
Sal Young
Date: November 14, 2005 06:51PM
by modifying the my.ini file in the C:\WINDOWS directory I was able to cut the time to under 3 hours which I still feel is too long. Here are some of the variables I changed:
key_buffer=256M
bulk_insert_buffer_size=128M
innodb_buffer_pool_size=128M
innodb_log_file_size=100M
It is going to take a while to discover all the different things that can be tweeked at startup. I'll experiment and see what happen.
Subject
Written By
Posted
November 13, 2005 12:03AM
Re: Bad performance when migrating data
November 14, 2005 06:51PM
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.