Bulk loading 500m rows into MySQL

load.sh

for month_table in action*.txt; do                                                                                          
  echo "$(date) splitting $month_table..."                                                                                  
  split -l 1000000 $month_table curmonth_                                                                                   
  for segment in curmonth_*; do                                                                                             
    echo "On segment $segment"                                                                                              
    time mysql -hlocalhost action_credit_silo <<-SQL                                                                        
      SET FOREIGN_KEY_CHECKS = 0;                                                                                           
      SET UNIQUE_CHECKS = 0;                                                                                                
      SET SESSION tx_isolation='READ-UNCOMMITTED';                                                                          
      SET sql_log_bin = 0;                                                                                                  
      LOAD DATA INFILE '$segment' INTO TABLE actioncredits                                                                  
      FIELDS TERMINATED by '\t' ENCLOSED BY '\"'                                                                            
      (@throwawayId, action, user_id, target_user_id, cause_id, item_type, item_id, activity_id, created_at, utm_campaign) ;
SQL                                                                                                                         
    rm $segment                                                                                                             
  done                                                                                                                      
  mv $month_table $month_table.done                                                                                         
done