I need to insert data into a mysql table sitting in AWS, I get the data in the form of multiple csv files, I am trying to process the files parallely and insert the data into a single mysql table. The job just hangs when I try to do that.

I tried to check if there was a deadlock created on mysql using show engine innodb status but I don’t see any deadlock.

I want to process the csv files and insert data in parallel to the mysql table.

I am new to stackoverflow, I am sorry if there was any missing information in the question, Any help is appreciated.