title: How to improve performance of Bulk Inserts in MYSQL
body: <pre><code>env: windows 10 
  version mysql 5.7
  Ram 32GB
  ide : toad mysql
  </code></pre>
  
  <p>i have sufficient hardware requirement but issue is the performance of insert into simple table that does not have any relation ships. i need to have index on the table.</p>
  
  <p>table structure </p>
  
  <pre><code>CREATE TABLE `2017` (
    `MOB_NO` bigint(20) DEFAULT NULL,
    `CAF_SLNO` varchar(50) DEFAULT NULL,
    `CNAME` varchar(58) DEFAULT NULL,
    `ACT_DATE` varchar(200) DEFAULT NULL,
    KEY `2017_index` (`MOB_NO`,`ACT_DATE`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  </code></pre>
  
  <p>I am using above for inserting the records into table. with out index it took around 30 min where as with indexing it took 22 hrs still going on.</p>
  
  <pre><code>SET autocommit=0;
  SET unique_checks=0;
  SET foreign_key_checks=0;
  LOAD DATA LOCAL INFILE 'D:/base/test/2017/2017.txt' 
  INTO TABLE 2017COLUMNS TERMINATED BY '|';
  commit;
  </code></pre>
  
  <p>i have seen suggestion to change cnf file, Could not find any in my machine. </p>