title: How to see progress of .csv upload in MySQL
body: <p>I have a very large .csv file, and I'm loading it into mysql with the LOAD DATA INFILE command.  Because it takes so long, I'd like to see how far along the upload has progressed.  </p>
  
  <p>I've tried 2 methods so far-
  First I simply did a SELECT COUNT(*) command to see how many rows had been inserted as the upload was in progress, but that always returns a count of 0.<br>
  Second, I tried SHOW PROCESSLIST and saw simply how long the query has been running.  sometimes the status says 'freeing data' or something to that effect.</p>
  
  <p>Does anyone know a good way to track the progress of a LOAD DATA INFILE command?  Also, does anyone know how to track the insertion rate?</p>
  
  <p>Thanks</p>