Is there any way to load huge amounts of data with LOAD DATA INFILE and make the load process have a low priority so the server stay responsive during the process?
I know about CONCURRENT and LOW_PRIORITY options for load data but that's not what I'm looking for since I load into a new database every time. I just don't want the MySQL server to slow down to a point where my website becomes unresponsive while I'm loading a few Gigs of data... Any idea? Thank you! ===== ----------------- Benoit St-Jean MySQL DBA Yahoo! Messenger: bstjean -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]