Hy,
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 :
http://dev.mysql.com/doc/refman/5.5/en/mysqlimport.html#option_mysqlimport_use-threads
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.