MySQL Performance comparison between loading comma separted vs fixed-width large file I have a file with 50 Gb, 7 columns and fixed-with. I couldn't succeed to load the data in my database (MariaDB 5.5.31, Windows 7, MYISAM) that is: after 15 hours I stopped the loading process. Does comma seperated file may perform better than fixed-width?
First of all, don't use myisam. 
Csv or fixed width, performance will be same. But if you load the dump in chunks it will be faster. Check out pt-fifo tool from Percona toolkit. It doesn't work well though if the dump contains newlines.