# how can i stop redo log while load data infile to a innodb table?

**URL:** <https://forums.percona.com/t/how-can-i-stop-redo-log-while-load-data-infile-to-a-innodb-table/1761>\
**Category:** Other MySQL® Questions\
**Created:** [February 16, 2012, 3:01am UTC](https://forums.percona.com/t/how-can-i-stop-redo-log-while-load-data-infile-to-a-innodb-table/1761 "2012-02-16T03:01:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![selfthing](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@selfthing](https://forums.percona.com/u/selfthing)\
**Post date:** [February 16, 2012, 3:01am UTC](https://forums.percona.com/t/how-can-i-stop-redo-log-while-load-data-infile-to-a-innodb-table/1761/1 "2012-02-16T03:01:05Z")

</div>

load data to a innodb table is very slow,but to a myisam is fast,so i figured out that writing redo log slows down the import speed,but i don’t know how to stop that while load data.anyone konw how?

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [February 17, 2012, 3:54pm UTC](https://forums.percona.com/t/how-can-i-stop-redo-log-while-load-data-infile-to-a-innodb-table/1761/2 "2012-02-17T15:54:36Z")

</div>

You can’t. InnoDB doesn’t allow you to disable it.

---

<div class="post-metadata">

**Author:** ![sterin71](https://avatars.discourse-cdn.com/v4/letter/s/5e9695/32.png) [@sterin71](https://forums.percona.com/u/sterin71)\
**Post date:** [February 18, 2012, 5:34pm UTC](https://forums.percona.com/t/how-can-i-stop-redo-log-while-load-data-infile-to-a-innodb-table/1761/3 "2012-02-18T17:34:42Z")

</div>

Selfthing:  
What kind of insert speed do you get compared to MyISAM?  
Do you have an INT auto\_increment as primary key or are your primary key inserted non sequentially?  
How large is your innodb\_log\_file\_size?  
Have you set innodb\_flush\_log\_at\_trx\_commit=2 in your configuration or are you using a RAID controller with a BBU cache?

As you can see in another post on this forum you should be able to reach quite fast insert rates on InnoDB also.

---

<div class="post-metadata">

**Author:** ![selfthing](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@selfthing](https://forums.percona.com/u/selfthing)\
**Post date:** [February 20, 2012, 4:18am UTC](https://forums.percona.com/t/how-can-i-stop-redo-log-while-load-data-infile-to-a-innodb-table/1761/4 "2012-02-20T04:18:26Z")

</div>

thank you,xaprb and sterin71.i will check the post you mentioned.  
the csv file is 8GB,no auto\_increment ,and the server is quite old,does’t have BBU cache,so innodb\_flush\_log\_at\_trx\_commit=1.  
i set innodb\_log\_file\_size to 1000MB,and innodb\_log\_files\_in\_group to 4,that helps speed up insert rate,but the speed rate is becoming slower and slower while table size increasing,if i split the csv file to several files,may that help speed up insert rate?