title: MySQL load data infile - acceleration?
body: <p>sometimes, I have to re-import data for a project, thus reading about 3.6 million rows into a MySQL table (currently InnoDB, but I am actually not really limited to this engine). "Load data infile..." has proved to be the fastest solution, however it has a tradeoff:
  - when importing without keys, the import itself takes about 45 seconds, but the key creation takes ages (already running for 20 minutes...). 
  - doing import with keys on the table makes the import much slower</p>
  
  <p>There are keys over 3 fields of the table, referencing numeric fields.
  Is there any way to accelerate this?</p>
  
  <p>Another issue is: when I terminate the process which has started a slow query, it continues running on the database. Is there any way to terminate the query without restarting mysqld?</p>
  
  <p>Thanks a lot
  DBa</p>