title: Implementing a MySQL command progress bar
body: <p>We are trying to parse a file and store it in a MySQL database.  The commands will be importing a large trace file the could be several gigabytes in size, so it it may of interest for the user to track the progress of the command.  We are using the following command:</p>
  
  <pre><code>String commandText = "SET AUTOCOMMIT = 0; "
                     + "START TRANSACTION; "
                     + "LOAD DATA LOCAL INFILE \'" + filePath + "\' "
                     + "INTO TABLE testdatabase.metadata "
                     + @"FIELDS TERMINATED BY '\t' "
                     + @"LINES TERMINATED BY '\n' "
                     + "(Position,"
                     + "Timespace,"
                     + "Duration,"
                     + "Disk,"
                     + "Request,"
                     + "Sector,"
                     + "Length); "
                     + "COMMIT;";
  </code></pre>
  
  <p>Is there a way to track the progress while the command is being executed in order to implement a progress bar?</p>