MySQL Forums
Forum List  »  MySQL Administrator

mysqlimport and use-threads
Posted by: Florent THOMAS
Date: October 17, 2011 04:04AM


I'm running under a Quad-Core AMD Opteron(tm) Processor 2352, 8 cores hosted by 1and1.

I have a file that can contain over 40.000 lines which is not so big but on the table that receive the mysqlimport command, I have some triggers. So that the computing could be very long.

So I decided to split my file and import the parts in parallel. I tried to use the use_threads options :
Unfortunately, as I run the following command :
mysqlimport -h localhost -u monuser --password=monpassword -L --low-priority --compress --delete --fields-terminated-by=',' --fields-optionally-enclosed-by='"' --lines-terminated-by='\r\n' --default-character-set=utf8 --use-threads=4 dossier1/monfichier.txt
dossier2/monfichier.txt dossier3/monfichier.txt dossier4/monfichier.txt
I still have one thread.

This command is called wheter by php whether by command line.

Thanks in advance for helping,

regards from france.

Options: ReplyQuote

Written By
mysqlimport and use-threads
October 17, 2011 04:04AM

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.