2
votes
0answers
301 views

Insert Speeds for large batches

In my application, my INSERTs seem to be taking a major chunk of the time. I have a large number of objects in memory (~40-50,000) which i want to insert into a table. Lets take a sample table ...
1
vote
2answers
1k views

jdbc+mysql: “Deadlock found when trying to get lock; try restarting transaction”

After recovering from a disk-full problem, I started getting these errors in my logs: java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction at ...