MySQL 5.7 Batch processing DeadLock
Posted by: Michael Hasler
Date: July 13, 2016 02:35PM

I developed a application which is importing lots of data from CSV files into several tables. To increase performance i ended up with a multi-threaded solution and batch transactions.
In a usual scenario there are 50 threads pushing 500 entries into the database.

Everything perfect until MySQL 5.7 ;(

After installing the latest version of MySQL, the application is not working anymore. Deadlock exceptions are thrown, and data is only partly imported, with the note to restart the transaction.

Can't find any help on the net nor specification, what changes affected this? How to fix this?

Help appreciated!

Options: ReplyQuote


Subject
Written By
Posted
MySQL 5.7 Batch processing DeadLock
July 13, 2016 02:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.