Re: MySQL Parallel Inserts

2010-12-21 Thread 杨涛涛
Hi. MySQL do the sql parse in the single way, just one thread. So if there are parallel insert statement, it will not faster than before. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com 2010/12/17 Andy > Shaw

Re: MySQL Parallel Inserts

2010-12-16 Thread Andy
Shawn/Krishna, Thank you. I will try this. -Andy On Tue, Dec 14, 2010 at 8:13 AM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > Hi Andy, > > I agree, prefer LOAD DATA INFILE... command for bulk loading. It is 30% > faster than normal inserts. > > Krishna > > > On Tue, Dec 14, 201

Re: MySQL Parallel Inserts

2010-12-14 Thread Krishna Chandra Prajapati
Hi Andy, I agree, prefer LOAD DATA INFILE... command for bulk loading. It is 30% faster than normal inserts. Krishna On Tue, Dec 14, 2010 at 8:02 AM, Andy wrote: > Greetings everyone. > > I am in a situation where I need to do parallel inserts into MySQL database > from inside my Perl program.

Re: MySQL Parallel Inserts

2010-12-13 Thread Shawn Green (MySQL)
On 12/13/2010 21:32, Andy wrote: Greetings everyone. I am in a situation where I need to do parallel inserts into MySQL database from inside my Perl program. Basically, I have several million records to insert into the database, and hence I would rather do them in parallel than doing them one at

MySQL Parallel Inserts

2010-12-13 Thread Andy
Greetings everyone. I am in a situation where I need to do parallel inserts into MySQL database from inside my Perl program. Basically, I have several million records to insert into the database, and hence I would rather do them in parallel than doing them one at a time. I looked around but did no