Thanks for the resource!
However, I am loading into a MyISAM table, while logging is disabled.
In a matter of fact, I was able to load the data at the end, after
disabling the keys. But now, as I try to create the keys, it takes a
huge amount of time. there are 250 Million rows in one of the tables.
My key_buffer_size is set to 4G, on a machine with 16G ram.
Are there any other system variable I could set in order to speed it up?
Thanks,
Shuly.
On Feb 24, 2009, at 5:17 PM, Baron Schwartz wrote:
Hello Shuly,
Try this. http://www.mysqlperformanceblog.com/2008/07/03/how-to-
load-large-files-safely-into-innodb-with-load-data-infile/
On Tue, Feb 24, 2009 at 1:08 PM, Shuly Avraham <sh...@cshl.edu> wrote:
Hi,
I have a huge table with about 50 millions of rows.
I dumped the table using mysqldump -T , as text dump, and now
trying to
import it to a database on another server, but it keeps hanging.
Are there any options or server variables I can set to help out
with it?
Thanks,
Shuly.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=ba...@xaprb.com
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org