I'm using MySQL LOAD DATA LOCAL INFILE to load csv files, and have noticed that during these loads, server output speed to other users diminishes eg long page download times, logins timeout. The LOAD DATA LOCAL INFILE operations themselves are very fast and effective.

What is the best way to approach this type of problem? I'm currently on a reasonably powerful VPS server (operates well when not processing LOAD DATA LOCAL INFILE) that contains both the main and mysql server.

Thanks for your time and suggestions.

  • Sounds like disk during LOAD DATA LOCAL INFILE. Do you have iostat figures for both times? Is MySQL not the "main" server? – Vérace Oct 16 '14 at 8:30
  • Is the table(s) you are loading InnoDB or MyISAM? @Vérace Do not discard locking. – jynus Oct 16 '14 at 9:08
  • @jynus - it's InnoDB. Does InnoDB not auto lock when inserting? Thank you btw. – Shaun Oct 17 '14 at 1:30
  • @Vérace - just looking up what iostat means - new term for me. Re MySQL not being the main server, I meant to convey that I don't have two separate physical machines ie one serving MySQL, and the other Apache. Just one machine serving both - I'm sharing a vps machine with a handful of other users. Thanks for your reply too. – Shaun Oct 17 '14 at 1:33
  • @Vérace - when you say both times, are you referring to the times each csv load start and finish? – Shaun Oct 17 '14 at 1:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.