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.