mysql - bulk insert troubleshoot loading data



i have a situation, not that critical, it is a mysql test database

we are experimenting to load data into it.

we are using LOAD DATA LOCAL INFILE to load data into mysql

mysql is installed on linux machine on my own dedicated server.

so we have full rights to do anything.


1. currently there are 212,000 rows in the table. 978Mb size for this table. when we try to insert data it hangs.

I checked table stats and max record count, everything is good.

This is what i like to accomplish. resolve this issue and allow us to load any number of records

we are trying 500records per load thru load data infile. we have a perl script to do this.

I even prepared to truncate the table and reload if needed. all data is test data. But not sure if this is the issue with the table or my environment variables

somepone who is knowledgeable with mysql admin, linux, perl, webmin (is my control panel) skill will be helpful

i can give full access to my machine so you can trouble shoot.

do not expect lot of money for this. $20 to $30 is lot for me.

Skills: MySQL

See more: perl mysql bulk insert, mysql bulk insert, mysql bulk load perl, server load test, problem stats, mysql data access, money on the table, money on table, linux perl bulk insert, bulk size mysql, mysql bulk insert script, load lot data mysql, insert bulk perl, perl bulk insert mysql, mysql bulk insert size, mysql bulk insert truncate, mysql bulk insert load data, linux webmin, troubleshoot, mysql test, mysql admin, insert, rows insert, resolve server, insert mysql table

About the Employer:
( 29 reviews ) bear, India

Project ID: #672076

2 freelancers are bidding on average $250 for this job


If there are a fix then I will fix it for you, I am ready to start now, I am expert in mysql

$250 USD in 0 days
(17 Reviews)

hello, check your pmb please

$250 USD in 0 days
(0 Reviews)